Parameter Query Question

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!!
 
K

Karl Dewey

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

Update Query: Enter Parameter Value 2
Several parameter queries with same question 0
Modify Parameter Query 1
Update Query with Parameter 3
Make table query: [Enter 1] AS Test 1
Using a form instead of a parameter query. 4
parameter query and making a new record 4
why my parameter query doesn't work? 0

Top