Calculating two calculated fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two calculated fields in a query, both being calculated by the
"Total:" row on the query. One is summing and the other is counting. I need
to calculate these two fields in order to create a percentage on a report.
The calculation I'm attempting is such: [SumOfField1]/[CountOfFieldA].
Field's 1 and A represent my summed and counted fields. When I do this,
Access gives me an error message stating that the fields cannot be found or
have been misspelled. Could this have to do with the fact that both fields
are being calculated in a query and their results are then being calculated
in a report? Any help you can give would be greatly appreciated.
Thanks,
Jason
 
I have two calculated fields in a query, both being calculated by the
"Total:" row on the query. One is summing and the other is counting. I need
to calculate these two fields in order to create a percentage on a report.
The calculation I'm attempting is such: [SumOfField1]/[CountOfFieldA].
Field's 1 and A represent my summed and counted fields. When I do this,
Access gives me an error message stating that the fields cannot be found or
have been misspelled. Could this have to do with the fact that both fields
are being calculated in a query and their results are then being calculated
in a report? Any help you can give would be greatly appreciated.
Thanks,
Jason
Click to expand...

Your analysis is exactly correct.

Use

Percentage: Sum([Field1]) / Count([FieldA])

instead - that is, recapitulate the expression in each term of the
further calculation, rather than using a calculated field in a further
calculation.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top