Help with a Query to return "OrderID" with no OrderDate

amasikonde 

This query should give you the requested result:

SELECT *
FROM Orders
WHERE OrderDate Is Null

Best Wishes,

Tieme

amasikonde 

I am not sure of the exact syntax but can you not use a where clause specifying OrderDate is null.

Wes Jan

amasikonde 

Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Microsoft Access space - please post Microsoft Access questions here in the future.