Searching two fields for the same information

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

KARL DEWEY

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.
 
Top