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

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"



"Lauren B" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>