is there a not between

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

in a query i can do between 1/1/04 and 12/31/04 can i
do a not between does that work?
 
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#)
 
NOT can be used with anything

Try:

WHERE [somefield] NOT (Between 1/1/04 and 12/31/04 )

or

WHERE [somefield] NOT Like '*/*/2004'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Between dates 7
IIF update query with Between Criteria 5
Search between two dates query 1
Changing Year in Date Range 1
Need help with time in a row. 3
Sum, group, date 2
Elapsed time between two dates 2
If logic question 2

Back
Top