Parameter Query Question

  • Thread starter Thread starter Amber
  • Start date Start date
A

Amber

Hello,

I would like to search two fields in the same table for a
value input by the user using a parameter query. I can
only seem to get the correct result when searching only
one field for the value. I'm new to this, any ideas?
Thanks!!
 
Make sure that you put the criteria for the second field
on a separate line.
This sets criteria to data in first field OR data in
second field.
 

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

Several parameter queries with same question 0
Parameter Query Won't Run 0
Multiple Parameter Crosstab query filter by form 1
Question about user-entered parameters in queries 1
Parameter Query No Results - Needs to Auto Create Record 4
Update Query: Enter Parameter Value 2
Union Queries - Parameter Value Prompt 2
Update Query with Parameter 3

Back
Top