How do I join 2 fields to a criteria in a Query?

C

Christen

I am trying to set a criteria with an OR clause in between 2 fields. Let's
call the 2 fields Field1 and Field2. I'm trying to do this example:
Only show the records that have this criteria:
Field1 = A, and Field2 = B,C,D,E,F,G

These 2 fields contain the same type of data, and we need to limit the
criteria together between the 2 fields?? Any ideas on how to do this when
using excel to build a query in Microsoft query?

Christen
 
Top