G
Guest
Good Morning,
I am using Access XP. I have a report that is based on a query. They enter
a date for criteria. It is just a single date. This report is run from a
switchboard.
We ran the report for 1/29/07 and it works fine. The report comes out
perfect.
We try to run the report for 1/30/07 and we get an error "There was an error
executing the command.
I tried to run just the query without the report and it runs just fine. The
data appears.
I then tried to run the report from the database window without using the
switchboard and I get this error "This expression is typed incorrectly, or it
is too complex to be evaluated. For example, a numeric expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables."
Then we tried to run the report for many other single days and it works just
fine.
The only date we have an issue with is 1/30/07.
Why would that be?
Any help would be great. I just don't understand why this date.
I am using Access XP. I have a report that is based on a query. They enter
a date for criteria. It is just a single date. This report is run from a
switchboard.
We ran the report for 1/29/07 and it works fine. The report comes out
perfect.
We try to run the report for 1/30/07 and we get an error "There was an error
executing the command.
I tried to run just the query without the report and it runs just fine. The
data appears.
I then tried to run the report from the database window without using the
switchboard and I get this error "This expression is typed incorrectly, or it
is too complex to be evaluated. For example, a numeric expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables."
Then we tried to run the report for many other single days and it works just
fine.
The only date we have an issue with is 1/30/07.
Why would that be?
Any help would be great. I just don't understand why this date.