One further point: a NOT IN (or IN for that matter) operation does not accept
parameters, only literal values, as its value list. So either use an AND
operation as I described ( it would an OR operation for the equivalent of IN
BTW), or you'll find a couple of ways of simulating the use of parameters at:
http://support.microsoft.com/kb/100131/en-us
Ken Sheridan
Stafford, England
Peg Hall wrote:
I get incorrect results when I do the following query:
Field a = "X"
Field b = Not "Y or Not "Z"
Field c = Between [Date 1] and [Date 2]
--
Message posted via
http://www.accessmonster.com