Parameter Query for a whole table....

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

Guest

Hi,

Is it possible to have a parameter query that looks through all the fields in a table? I want to use a LIKE criteria within a PARAMETER query that can search the whole table, instead of just one field.

Is this possible?

Thanks,

Anton.
 
Anton,

I think if you put exactly the same parameter prompt in the criteria of
more than one field in a query, the prompt will only pop up once, and
the criteria will be applied to all fields where the criteria was entered.
 
Steve,

Thanks for trhe quick response. Worked faultlessly!

Thanks,

Anton
 
You must log in or register to reply here.

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

Update Query with Parameter 3
Multiple Parameter Crosstab query filter by form 1
Use Same Parameter For Different Fields Within Query? 1
Parameter queries 2
Parameter Query No Results - Needs to Auto Create Record 4
Parameter Queries in Crosstab Query 2
Parameter Query Won't Run 0
Using Combo Boxes as a Source for Parameter Queries 2

Back
Top