"Expression typed incorrectly"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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!
 
While viewing your query, select View->SQL. You can copy the SQL statement
and paste it into a reply.
 
Back
Top