Query by Date Issues

[cooltech73]

I have a table that tracks customer orders (by date of order) and I need to find out all customers who have ordered prior to January 1, 2006.

I am stuck between using a Where or a Between criteria but am still having problems with the correct phrasing.

Please help!

 

[ejstefl]

I don't see why you wouldn't use:

WHERE tblOrders.OrderDate < 1/1/06

 

[cooltech73]

Okay, and I apologize in advance for my lack of knowledge in this matter, but I took your statement (thank you very much by the way) and put it in my criteria field. It automatically added the brackets but I modified it to looke like: "WHERE[Tbl_Orders].[Date of Order]"<#1/1/2006#

Now, however when I run it, it doesn't provide any information. I had a Between statement in there before that was:

Between[01/01/2004] and [12/31/2005]

and that supplied information back to me.

Maybe I am not describing it the right way, I don't know.

 

[ejstefl]

You would only put:

<#1/1/06#

in your criteria field. You don't need to type the where part.

 

[cooltech73]

Got it, thanks again!

 

[cooltech73]

It works great, thank you so very much.

I know that it was a very easy fix for you but I really appreciate it.