Searching two fields for the same information

  • Thread starter Thread starter FJB
  • Start date Start date
F

FJB

Is it possible to use the same criteria to search two or more specific
fields? What I am looking for is the ability to enter one case number
(2006008100) and locate that number in either the "Case Number" or
"Previous Case Number" fields. Thanks for your help.
 
Yes. Use something like this -- [Enter Case number] and put in the
criteria row of design view of query.
Copy the criteria and paste in a different row for the second field. This
forms an OR statement so the Case number can be in either field. The reason
I say to copy and paste is to make sure it is identical in both places.
 

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

Count text values in a Access Field 0
extract 3 numbers from a string 0
Access Dcount (multiple criteria) 3
Parameter search in a text field 1
Query for a report 1
Search for number in memo field 8
search multiple criteria 0
Enter one or many criteria 5

Back
Top