How many criteria can I add to one query

[Patti]

Hello,

I'm relatively new to using access and still learning. I was hoping someone may be able to tell me how many like functions i can put in one query? I'm trying to use like in 10 fields, which relate to a search form I have created.

Any help would be greatly appreciated.

Thanks

 

[sneuberg]

This Access 2016 specification states that a SQL statement is limited to about 64,000 characters but I don't see any other limitations about functions.

 

[Patti]

Thanks for your help Steve.

 

[The_Doc_Man]

In general, the answer is "whatever you can fit in two places: (a) in a string of 64K length and (b) in your head." When the query gets too complex for you to figure it all out, you have too many criteria clauses.

Also, watch for ANDs and ORs when you are combining criteria. After a while the parenthetical nesting can become awkward.