P
pkb01032
I have a report based on a parameter query. The parameter query asks for a starting date and an end date. When I run the query, I can enter either 3/19/04 as the end date or 3/20/04 as the end date, and the query runs correctly. However, when I run the report based on the query, I can enter 3/19/04 and sucessfully build a report, but I cannot enter 3/20/04 and successfully build a report. The error message I get is: "The 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." There are a few expressions in the report, but they are simple Rate*Hours expressions. AND, the report will build with those expressions in the report if I use a date PRIOR TO 3/20/04. So, I don't suspect that the expressions are typed incorrectly. And, since the report will build if I use 3/19/04 instead of 3/20/04, I don't suspect that the format of the date is a problem. Any ideas why the report won't build from a parameter query when the date reaches 3/20/04 or later?