max. # of "AND operator" in criteria

  • Thread starter Thread starter sb2008
  • Start date Start date
S

sb2008

Have been asked at work to find out the maximum number of AND operators you
can have in the Criteria field of a query in Design mode (Access 2007). Have
been searching the web in both Access and SQL and can't find. Anyone know??
 
Don't know if it has changed for 2007 but I found the following in the
Help file specifications for 2003.

Number of ANDs in a WHERE or HAVING clause 40
 
sb2008 said:
Have been asked at work to find out the maximum number of AND operators you
can have in the Criteria field of a query in Design mode (Access 2007). Have
been searching the web in both Access and SQL and can't find. Anyone know??
Click to expand...


Search Help for "Specifications"

I don't know about A2007. Originally it was 40, but was
bumped up to 99 in A2002.
 
Thx for the info! Using the search term you wrote "Number of ANDs in a WHERE
or HAVING clause" I found an update for Access 2007 and the new max is 99.
Can't believe an hour of searching the web with terms like "Maximum" and
"highest" got me nowhere. Appreciate your quick response!
 
Back
Top