Calculating Averages in reports

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

Guest

I have a report and and trying to calculate averages but can't ge the numbers
rights

C1 C2 C3
C4
total 77 620 12
106

Avg (what access says) C2/C1 C3/C2 C4/C2
7.9 2.71% 24%

What a calculator says 8.05 1.9% 17%

you can also send replies to (e-mail address removed)

Formula I'm using
=Avg([C2])/([C1]), should be 8.05 but am getting 7.9 in the report
 
Why are you using Avg( ) when there is only one value of C2 and one value
of C1? There is nothing to average with only one value.
 
I know, I did some more searching on the internet and changed over to "Sum",
was not using on the other half of the formula, but finally got it to work.

Duane Hookom said:
Why are you using Avg( ) when there is only one value of C2 and one value
of C1? There is nothing to average with only one value.

--
Duane Hookom
MS Access MVP
--

mikcin said:
I have a report and and trying to calculate averages but can't ge the
numbers
rights

C1 C2 C3
C4
total 77 620 12
106

Avg (what access says) C2/C1 C3/C2 C4/C2
7.9 2.71%
24%

What a calculator says 8.05 1.9% 17%

you can also send replies to (e-mail address removed)

Formula I'm using
=Avg([C2])/([C1]), should be 8.05 but am getting 7.9 in the report
Click to expand...
Click to expand...
 
Back
Top