Returning all records that match in 4 fields

[Ali]

I'm looking for a way to return all records that match in
4 fields. For instance, I want all records with the AIG
client name to be selected whether AIG appears in Buyer
1, Buyer2, Seller 1, or Seller 2 fields.

I have 75 clients that I want to query using one report.

I tried using Like'*AGI*' but it did not work.

Thanks,
Ali

 

[John Spencer (MVP)]

You need to set up or criteria in your query.

If you are using the query grid, it would look something like this.

Field: Buyer1 Buyer1 Seller1 Seller2
Criteria Line1: AIG
Criteria Line2: AIG
Criteria Line3: AIG
Criteria Line4: AIG

 

[Les]

You would want your query design to look like:

Field Buyer1 Buyer2 Seller1 Seller2

Criteria "AIG"
"AIG"
"AIG"
"AIG"
When criteria are on different lines, it is like OR
conditions. So it's like Buyer1 = AIG or Buyer2 = AIG,
etc.