how do I make a parameter query search for part of a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a parameter query to search in a postcode field, however this
field has many postcodes in it and I will only want my query to search for
one at a time. How can I define my query so that it doesnt have to match the
whole of the field.
 
Jen666 said:
I have designed a parameter query to search in a postcode field, however this
field has many postcodes in it and I will only want my query to search for
one at a time. How can I define my query so that it doesnt have to match the
whole of the field.
Click to expand...

Set the column's criteria to:

Like "*" & [Enter Post Code] & "*"
 
Back
Top