Calculations in Access

[AZKing]

Hello,

I am trying to create a query to calculate certain fields in from a table. The calculations are pretty simple, they are just counts and sums. Once I run it I get the following error 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."

Does anyone know why this message is coming up? Is Access limited in performing calculations?

Thanks for any advice.

[ADezii]

Hello,

I am trying to create a query to calculate certain fields in from a table. The calculations are pretty simple, they are just counts and sums. Once I run it I get the following error 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."

Does anyone know why this message is coming up? Is Access limited in performing calculations?

Thanks for any advice.

We will need the SQL.

[NeoPa]

Sometimes Access gets confused and sometimes this is due to a small bug in the SQL. The error message it comes out with is sometimes inappropriate. As ADezii says, we'd need to see the SQL to find the problem.

[VoiceOfThunder]

Please copy and paste your formula here, so we can look and see what's is wrong with it. Sometimes, it just wrong syntax.