"Expression typed incorrectly"

[WAR]

I have a query / report in which I enter the following 3 variables: Year,
Period, and Week. Recently, in the report, when I enter 2007 / 2 / 4 or 2007
/ 3 / 4, I get the error "This expression is typed incorrectly, or it is too
complex to be evaluated." Going back 7 years, this has never happened before.

If I go into the query, and enter the same thing, the data is retrieved. I
can think of no reason that this should not work correctly in the report.

Any suggestions?

 

[Duane Hookom]

How about sharing your SQL view? We have no idea how you "enter the following
3 variables".

If your query works then you might have a control source that creates your
error.

 

[WAR]

I'm probably not as knowledgeable as most, I am unclear about how to show a
SQL view . . . . Can you provide a reference or simple instructions? Thanks!

 

[Duane Hookom]

While viewing your query, select View->SQL. You can copy the SQL statement
and paste it into a reply.