Thread: Parameter query with and multiple "NOT / OR" selection criteria
View Single Post
  #1  
Old June 1st, 2010, 05:04 PM posted to microsoft.public.access.queries
Peg Hall
external usenet poster
  
Posts: 1
Default Parameter query with and multiple "NOT / OR" selection criteria
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]