More help with multiple 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 having my query design look like:

Field Buyer1 Buyer2 Seller1 Seller2

Criteria [Enter an account name]Like'*AIG*'
Like'*AIG*'
Like'*AIG*'
Like'*AIG*'

And this works fine when I want my report to show all
actions of AGI but does not work when I enter another
client name.

How do I fix this?

Thanks, Ali

 

[John W. Vinson [MVP]]

-----Original Message-----
I'm looking for a way to return all records that match in
4 fields.

Instead of putting

LIKE "*AIG*"

under each field, put

LIKE "*" & [Enter client code:] & "*"

You may want to reconsider your table design, though: what
will you do if you have THREE buyers or sellers someday?
It appears that you have a one to many relationship
embedded within your single record!

John W. Vinson/MVP