I have a report based on a parameter query that pulls records Between #date# And #date#. One field, [Margin%] is a complet calculated field.
On the report I have, example:
[Margin%]
[Comm%]
[Rcvd$]
I insert a calculated field, [NewField], that does the following:
[Rcvd$]*[Margin%]*[Comm%]
At this point all is fine and the report produces the correct information.
When I try to sum the [NewField] into the report footer, I get the following error message:
"This expression is typed incorrectly or it is too complex to be evaluated. For example, numerical expressions may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."
I'm wondering if this is because of the complex calculation in the [Margin%] field and to sum it is just too much for Access to handle.
I did try to put the [NewField] into the query, add it to the report and then sum it and I get the same results as above.
Any ideas on how to work around this? Any help is appreciated.
On the report I have, example:
[Margin%]
[Comm%]
[Rcvd$]
I insert a calculated field, [NewField], that does the following:
[Rcvd$]*[Margin%]*[Comm%]
At this point all is fine and the report produces the correct information.
When I try to sum the [NewField] into the report footer, I get the following error message:
"This expression is typed incorrectly or it is too complex to be evaluated. For example, numerical expressions may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."
I'm wondering if this is because of the complex calculation in the [Margin%] field and to sum it is just too much for Access to handle.
I did try to put the [NewField] into the query, add it to the report and then sum it and I get the same results as above.
Any ideas on how to work around this? Any help is appreciated.