I'm running a query that results in two time fields: a Start Time and a Ship Time. When I create a report and sort by the Ship Time, I get no problem. However, when I try and sort by the Start Time (which is calculated in the query by subtracting an Order Time from the Ship Time), I get an error that says, "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 expresssion by assigning parts of the expression to variables."

Do you think the subtraction of two times is making it too complex? Is there a way to make it simpler or an easy fix to this?

Thanks!

Sounds like a field is giving you a negative time? You could create a query to check for this fairly simply.

Thanks so much. I had one record that was giving me an error which caused the message. I fixed the problem and now it works!