S
Steve Y
I have a table of sales for our customers. There are all entered based on
the first day of every month. In my table design I have the Date/Time format
set to Short Date.
Now I am building a query and want the operator to enter a date. The
problem is that the date appears in the table as 5/1/2006 and if the operator
enters the requested date as 05/01/2006 it does not retrieve the fields???
Please let me know what I am doing wrong.
the first day of every month. In my table design I have the Date/Time format
set to Short Date.
Now I am building a query and want the operator to enter a date. The
problem is that the date appears in the table as 5/1/2006 and if the operator
enters the requested date as 05/01/2006 it does not retrieve the fields???
Please let me know what I am doing wrong.