Forum Discussion

amasikonde's avatar
amasikonde
Copper Contributor
Jul 29, 2020

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...
Woldman's avatar
Woldman
Iron Contributor
Sep 17, 2020

amasikonde 

This query should give you the requested result:

SELECT *
FROM Orders
WHERE OrderDate Is Null

 

Best Wishes,

Tieme