Wildcard in a query problem.

[postmanphat]

Hello...

I've got a field in a table full of postcodes e.g:

BB1 F34
BS2 T54
BS2 Y30
CW3 T24

I want to be able to build a query that prompts the user to enter the first part of the postcode (e.g BS) and for the query to return all the rows where the postcode begins BS.

I haven't used Access for a while and I know this is dead easy but for the life of me I can't work it out!!!

Cheers in advance

Dave

 

[jimirvine]

Hi

try

Like [Enter start of postcode] & "*"

HTH

Jim