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

[amasikonde]

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	2461	REFI128	9093
10001	1/10/2005	2905	ALBE008	5631
10002	1/12/2005	2938	EXVI008	6957
10003		2011	EXVI008	3729
10004	1/12/2005	2143	PICH008	5293
10005	1/13/2005	2952	HOJI064	8598
10006	1/14/2005	2726	EXVI016	1174
10007	1/15/2005	2820	MORA128	8123
10008	1/15/2005	2665	KORO016	6669
10009		2302	VIRG064	1207
10010	1/16/2005	2683	MORA128	5631
10011	1/17/2005	2662	FRAN128	6870
10012		2981	KORO016	5631
10013	1/18/2005	2162	MORA128	7634
10014	1/20/2005	2390	PICU032	1174
10015	1/21/2005	2732	OBLI128	9584
10016	1/21/2005	2062	PURE032	6957
10017		2233	MANZ016	7634
10018	1/22/2005	2144	PICH008	2234
10019	1/22/2005	2156	REFI064	6957
10020		2694	PURE032	1207
10021	1/24/2005	2956	ALBE064	7634
10022	1/24/2005	2932	PEND128	4105
10023	1/26/2005	2461	KORO128	2998
10024		2895	PEND016	6870
10025	1/27/2005	2397	LIGH064	6372
10026	1/28/2005	2934	MANZ128	1644
10027	1/30/2005	2938	FRAN008	5692
10028	1/31/2005	2219	REFI008	4747
10029	2/1/2005	2809	HOJI128	9584
10030	2/2/2005	2799	MANZ064	8972
10031		2553	OBLI016	9900
10032	2/4/2005	2022	REFI016	8274

[#2]

@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. 

[#3]

Thank you for helping and heads-up...@Eric Starker 

[#4]

@amasikonde 

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

Wes Jan

[#5]

@amasikonde 

This query should give you the requested result:

SELECT *
FROM Orders
WHERE OrderDate Is Null

Best Wishes,

Tieme