need help with query

[Anelka]

hi im having trouble with my query.
ok what i want to do is only show certain records, i want it to pull the record according them to there postcode (in my table postcode is seperate to postcode unit).

ok what i can do at the minute is pull say M11 and M1 using criteria and Or but that obviously is only 2 postcodes. what i need it to do is show more that 2 queryies.

the expression iam using at the minute is [postcode]="M11"
how do i make it find more postcodes.

 

[Anelka]

ok worked it out

hi again.
worked out how to do it.
didnt relise you had to do it this way
[postcode]="m11" or "m1" or "m5"

thought i could use "and"



thanks anyways

 

[RV]

Or use the IN operator:

[postcode] IN ("m11","m1","m5")

RV