By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,020 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Query Where Date Is Not Equal To Certain Value

mkremkow
P: 5
Access 2003

I am trying to make my query exclude all records where the Request Delivery Date is not blank AND is not 03/31/2008. The SQL reads as follows:

WHERE ((([Job Log].[Graphic Designer Name]) Is Not Null) AND (([Job Log].RequestedDelivery) Is Not Null) AND (([Job Log].[Date Closed]) Is Null))
ORDER BY [Job Log].RequestedDelivery;

I can get it to run until I try to exclude the March 31, 2008 records. Any hints or tips for this beginner?

Thanks, Marjo
May 7 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,365
When using a date you have to tell it that it's a date by using # signs.
i.e. #1/1/2003#, #8/29/2008# and so on.
May 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.