Avg Function

[hiker8117]

Hello: When you look up help for this function it shows how you can Avg 2 fields like Tax and Freight: Example: AVG([Tax]+[Freight]). However, when I attempt to do this I get summed totals in lieu of an average. In my query the fields are grouped on each item and the numbers in these fields are not summed. When I create a new calculated field as an example:



Avg([March]+[April]) I get the summed qty's and not an average. Any help would be appreciated.

Thank you

Gene

[thhui]

Avg is a group function in access query.
This is not the same as average of 2 numbers.

It is based on group

So if the group contains only 1 instance.
Then avg() will be the same value of the underlying field or expression.

[hiker8117]

Avg is a group function in access query.
This is not the same as average of 2 numbers.

It is based on group

So if the group contains only 1 instance.
Then avg() will be the same value of the underlying field or expression.

Not quite sure what you mean by a group function. If I group on my items in the total field, is this what you mean?

Regards
Gene

[thhui]

If a table contains two fields
[March] and [April]

If the table has 2 rows

Row 1 [March]=3 [April]=4
Row 2 [March]=5 [April]=6

Avg([March]+[April])=[(3+4)+(5+6)]/2=9

PS: Divide by 2 because of 2 rows

In Access SQL function, Avg is based on rows not columns