criteria limit for queries

[ironj32]

just curious to know if there is a limit to how many "criteria" you can use in a query?

[OBP]

Yes there is actually if you use the "Or" statement and have them on different lines, then I think it is about 46.
But the limit on one line is the number of criteria is the same as the number of fields.

[andrew93]

Hi

There are a number of limits in Access (and queries) which you can read about here:
http://office.microsoft.com/en-us/access/HP051868081033.aspx

HTH, Andrew