Raja said:
What is teh maximum criteria I can put in one field in a query?
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.
