Report Error

A

Anthony

I have a daily report that I run. When I click the command button I am
prompted for a date. For some reason when I enter todays date 12/09/2008 I
get an error stating that the expression is typed incorrectly, but when I
enter any other date it works. Any suggestions as to what I'm doing wrong?
 
M

Maarkr

Did you open the source query and run it with that date? Do you have any
records in the table/query for the error date? Did you try entering other
ways, like 12/9/08, or 9 Dec 08 (is the format/input mask such that you must
enter it a certain way)?
 
T

Tom van Stiphout

On Wed, 10 Dec 2008 05:00:01 -0800, Anthony

I can't say from the information you provided. Post the SQL statement
for the report (edit the report's RecordSource property with the
button next to it, switch to SQL view, and post that text).
Are you in a country that uses the mm/dd/yyyy date format?

-Tom.
Microsoft Access MVP
 
A

Anthony

I fixed it..there was an error with data in the table, I missed it during the
review. Thanks for your input..
 
Top