Criteria

  • Thread starter Thread starter Raja
  • Start date Start date
Raja said:
What is teh maximum criteria I can put in one field in a query?
Click to expand...
There is no way to answer this question, which depends on other factors
which you can see by searching Access online help for "specifications". One
of the key specifications is "Number of characters in a cell in the query
design grid"m which is 1024. Another is "Number of ANDs in a WHERE or HAVING
clause", which is 99.

I will say that the fact that you need to ask this question probably
indicates that you should be looking into another way to accomplish your
goal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Use In() Expression as Query criteria with guts from Function 1
Listing all fields in a query 0
Problem with the Like Operator 2
Use criteria in field for fieldname in query 2
iif in the criteria 3
Update date field to Is Null in an update query 3
All-Record criteria in a query...hmmm 4

Back
Top