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