Access Report Broken 1

[dwg23]

Hello,
we have an old access data base that we use to keep track of build jobs and production schedules.
It was written in Access 2003 and now after opening it in 2013 one of the reports is broken.
when you click on the report to run it a box pops up asking you to input a Parameter Value, In this case it is the Start Month/Day of the Report, we would enter 1/1. You click OK and another box pops up asking for the End Month/Day and we would enter 3/31 as we report by the quarter, and again click OK. after clicking OK for the second time an error box pops up with this message.
" 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."

I can't get any simpler that 1/1!
any ideas on how to fix this?

 

[dhookom]

Make a copy of the query and begin removing columns/expressions until it works. What you most recently removed will be the culprit. Let us know what you find.

Duane
Hook'D on Access
MS Access MVP

 

[dwg23]

Finally success!
I went through the query as asked and while it had nothing wrong with it, it did pull information from another query, it failed with a type mismatch error.

SELECT [work order], sum( [actual build time] ) AS build_time
FROM [WO Assembly Time]
GROUP BY [work order]
ORDER BY [work order];

The sum( [actual build time] was set as Text, so the query was trying to total text as far as it was concerned.
I changed the column to a number and it worked!
not sure how it happened but we are off and running again!

Thanks to all of you for all the help!
DWG23