Hello:
  I have a question and figured I would turn here. I am querying multiple fields in the same table. Now, I know that if I want to query them for the same keyword, I need user the same criteria, which I am. My problem is that if the keyword shows up in even one of the fields, I need it to show up.

Any thoughts on how to do this?

Thanks in advance.
Best Regards,
Arholly

Nevermind, changed to the SQL view and changed the AND to OR and it worked.

Arholly:

Could you fill me in as to the SQL code you used for this query? I want to search three separate fields for a single keyword. The query needs to yield every record in which the keyword appears in any of these three fields.

Not quite sure how to proceed. I would appreciate the enlightenment.

Best,
C