Averaging in a form

[Tabco]

I'll try to explain better.
In a report I have a column for budgeted speed or units
per hour. This number comes from a table and is related to
a product. If I input more than one product for that line
I want to be able to get an average budgeted speed for
that line.
I created a textbox with a calculation that says
=avg([budgeted speed]) When I call up the report the math
isn't right. Ex. I ran three products with the budgeted
speed of 13500, 12000, 11100 The avg. should be 12,200.
The report shows 12,525. Instead of dividing by 3 it is
divided by 2.9221 I did notice that if I only ran two
products on that line the avg. comes out right.
How can I force it to divide by the number of products ran.

 

[Michel Walsh]

Hi,


I doubt Access itself is in error. I suspect that either the displayed
number are FORMATTED to display something else than what they really are,
such as using a round-up schema so that 13511 is displayed 13500. When you
ask for the average, the real data, not what is shown through format or
rounding, is what is effectively averaged. Another possible case could be
that our equation uses average of averages, which is wrong, in general.



Hoping it may help,
Vanderghast, Access MVP