When I run my query, I'm getting this message:
"You tried to execute a query that does not include the specified expression '([Net Amount]-[Accrual Amount)]/[Net Amount]' as part of an aggregate function."
The fields [Accrual Amount] and [Net Amount] are in the Total category of "Sum" and the rest are "Group By."
I vaguely understand the problem... I am trying to do a record-by-record calculation on fields that are themselves sums of other records. But... so what? I want the expression above to be done on the sums, after the sums are calculated. I guess I could just get the sums first, then run another query on the results, but is that necessary?
Thanks!
"You tried to execute a query that does not include the specified expression '([Net Amount]-[Accrual Amount)]/[Net Amount]' as part of an aggregate function."
The fields [Accrual Amount] and [Net Amount] are in the Total category of "Sum" and the rest are "Group By."
I vaguely understand the problem... I am trying to do a record-by-record calculation on fields that are themselves sums of other records. But... so what? I want the expression above to be done on the sums, after the sums are calculated. I guess I could just get the sums first, then run another query on the results, but is that necessary?
Thanks!
