Re: SQL in code (A97)

Access always generates a lot of superfluous parentheses and references to the table name in its queries. This is necessary because you might modify the design of the query later on. When you write SQL strings in code however, there is no need for this. To check if something is A or B or C, you can use <font face="Georgia">In('A', 'B', 'C')</font face=georgia>. To check if something is not A, B or C, use <font face="Georgia">Not In('A', 'B', 'C')</font face=georgia>. So in your example: