Forum Discussion
Help with a Query to return "OrderID" with no OrderDate
I need help to write an Access query to turn OrderID with no Corresponding OrderDate. The Table I'm using is as shown below: OrderID OrderDate CustID ProductID SalesID 10000 1/10/2005 24...
I am not sure of the exact syntax but can you not use a where clause specifying OrderDate is null.
Wes Jan