query question

[Lauren B]

How can I write a query to return entries that have a name present in any of
5 fields? The name is inputted through a combo box drop down menu and may
be present in either FIELD1, FIELD2, FIELD3, FIELD4, or FIELD5. The name
does not have to present in all fields, I just need my query to return
responses if the name selected is in any of 5 fields.

Thank you in advance for any assistance.

LB

 

[Rick B]

Just place your criteria under each of the fields mentioned, but put it on a
separate row in the criteria section. Placing criteria on separate rows
creates "OR" searches. Placing criteria all on onw row creates "AND"
searches.


Field1 Field2 Field3 Filed4 Field5
="smith"
="smith"
="smith"
="smith"
="smith"