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] & "*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search specific postcodes 3
Text field in Access query is blank 8
Query help 1
Appending null data and moving! 4
Parameter Queries 2
Query table using criteria from an Excel document 2
Creating a query that will search for first 3 letters of a postcod 2
Access fails to find refered experient 2

Back
Top