Date Entry in Query Problem

[Guest]

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.

 

[Brendan Reynolds]

If you can post the SQL from the query, someone will probably be able to see
what the problem is. With the query open in design view, choose SQL View
from the View menu.

The format in the table design is unlikely to have anything to do with the
problem. That only determines how the data is displayed, it does not change
the way that the values are actually stored and compared.

I'm assuming that the data type is Date/Time.

 

[i_takeuti]

If you can post the SQL from the query, someone will probably be able to
see what the problem is. With the query open in design view, choose SQL
View from the View menu.

The format in the table design is unlikely to have anything to do with the
problem. That only determines how the data is displayed, it does not
change the way that the values are actually stored and compared.

I'm assuming that the data type is Date/Time.