On Tue, 31 Oct 2006 11:56:09 +0800, "00KobeBrian" wrote:

In fact, I just found out that there is a limit on the number of criteria in
a query, right? If I pass over the maximum, say field 1 = a or b or c....
until maximum in query, is there a workaround? Thanks.

Several. The WHERE clause as written will not work anyway!

First try a criterion of

IN ("A", "B", "C", ...)

That will get you some savings (the QTC error arises when the compiled
query exceeds 64KBytes, and each OR clause contributes some).

A better solution might be to put the criteria as records in another
table and use a JOIN, joining Field1 to the field containing the
criteria.

John W. Vinson[MVP]