D Dan Oct 21, 2004 #1 in a query i can do between 1/1/04 and 12/31/04 can i do a not between does that work?
A Allen Browne Oct 21, 2004 #2 Sure: Not (Between #1/1/2004# And #12/31/2004#) Watch the nulls. If you want all records except those between the dates, and some have no date entered, you need: Is Null Or Not (Between #1/1/2004# And #12/31/2004#)
Sure: Not (Between #1/1/2004# And #12/31/2004#) Watch the nulls. If you want all records except those between the dates, and some have no date entered, you need: Is Null Or Not (Between #1/1/2004# And #12/31/2004#)
M [MVP] S.Clark Oct 21, 2004 #3 NOT can be used with anything Try: WHERE [somefield] NOT (Between 1/1/04 and 12/31/04 ) or WHERE [somefield] NOT Like '*/*/2004'
NOT can be used with anything Try: WHERE [somefield] NOT (Between 1/1/04 and 12/31/04 ) or WHERE [somefield] NOT Like '*/*/2004'
