Calculating Averages in reports

[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

 

[Duane Hookom]

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.

 

[Guest]

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.

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
--

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