Returning all records that match in 4 fields

  • Thread starter Thread starter Ali
  • Start date Start date
A

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