MS Access database help needed (2003)

  richierich 14:05 23 May 2009
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 2009

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 2009

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 2009

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 2009

I just get a message Invalid Syntax

  richierich 07:53 26 May 2009

Sorry , got it right now,
thanks

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?