Multiple And/Or Criteria

[Brian Berg]

I have a rather large query that is pulling information from seven tables. I have set up a form for the users to enter the criteria they want to search by but I have run into a snag. I need to allow them to search by any of the 16 different criteria.

I have been able to search by the 16 criteria using Or but I cannot figure out how to use an And for any combination of the criteria without removing the Or capability.

I don't have any experience with SQL or VB and have created the query in design view.

Let me know if it's possible to use an And/Or with this many criteria.

Thanks in advance,
Brian

 

[Rich_Lovina]

Have you tried building a query on a query, so you do your OR's first, then in the 2nd query do your ANDS?