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

Query "Is Null" not working with date

P: 1
I've made a query using QBE in Access 2010. I need to filter out all the results that do not have a value for Exception_Date_Completed.

I used the Is Null criteria and it is just giving me a blank date sheet view when I hit run. Any help would be appreciated!

Below is the SQL for the statement:

Expand|Select|Wrap|Line Numbers
  1. SELECT Machine.Machine_Plant, Exception.RptNum, Exception.Exception_Date_Entered, Machine.Machine_ID, Machine.Machine_Dept, Machine.Machine_Location, Exception.Exception_Problem_Description, Exception.Exception_Completed_Date
  2. FROM Machine INNER JOIN (KeyWord INNER JOIN ([Exception] INNER JOIN ExceptionWork ON Exception.RptNum = ExceptionWork.RptNum) ON KeyWord.KeyWord = Exception.KeyWord) ON Machine.Machine_ID = Exception.Machine_ID
  3. WHERE (((Exception.Exception_Completed_Date) Is Null));
Nov 29 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,427
If you're trying to filter out the dates with no value, then you need to use IS NOT NULL not IS NULL.
Nov 29 '11 #2

Post your reply

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