MS Access database help needed (2003)

  richierich 14:05 23 May 09
Locked

making a data base I want to make a query to select just first half of postcodes only, ie all those beginning SW1.
I realize i could split the postcodes over 2 columns and just query the first column but is it poss to just have one column and query ist part of postcode. (hope this makes sense)

  recap 20:04 23 May 09

The following will bring in all the post code, i.e. SW1 2TT when entered in the Criteria field in a query and, in the Input Mask of a Table.

Like "*"+[Enter Post Code]+"*"

  richierich 09:27 24 May 09

doesnt tell me what i have asked ie i want to put in sw1 to display all postcodes beging with sw1

  Jurdz 07:07 26 May 09

Recap is correct, sort of.
Put Like "*"+[Enter Post Code]+"*" in the criteria field of your query and when you run the query you will get a prompt asking ENTER POSTCODE.
You then type in SW1 and the query should return all postcodes CONTAINING "SW1". To get postcodes BEGINNING with SW1, you should enter the criteria Like [Enter Post Code]+"*"

Alternatively, you could just enter Like "SW1*" in the criteria fied but your query will always only return postcodes beginning with SW1

  richierich 07:48 26 May 09

I just get a message Invalid Syntax

  richierich 07:53 26 May 09

Sorry , got it right now,
thanks

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…