Query "Is Null" not working with date

[Matt Sackley]

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:

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
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
WHERE (((Exception.Exception_Completed_Date) Is Null));

[Rabbit]

If you're trying to filter out the dates with no value, then you need to use IS NOT NULL not IS NULL.