Search results

It works great, thank you so very much. I know that it was a very easy fix for you but I really appreciate it.

Got it, thanks again!

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

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!