Query

[Ali]

Right now I'm using Critera (under Queries and Design
View) to select all records that match in one field.

I'm looking for a way to retun 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.

Thanks,
Ali

 

[Gerald Stanley]

IN Design View, select columns Buyer1, Buyer2, Seller1 and
Seller2. Then in the first criteria row, put Like '*AIG*'
in the column for Buyer1, in the next criteria row, put
Like '*AIG* ' in the column for Buyer2 and so on.

Hope This Helps
Gerald Stanley MCSD

 

[Guest]

I have 75 clients that I want to query. Will this method
work for all of them using one report?

 

[Gerald Stanley]

It would but it would be a lot of typing and you would have
to think about the maintenance overhead should you wish to
change the set of clients.
As an alternative, I would recommend putting the 75 client
names in a table. Then the SQL in the criteria would be
IN (SELECT clientName FROM ClientReports)
where ClientReports is the name of the new table and
clientName is the name of the column in that table.

Hope This Helps
Gerald Stanley MCSD