sum or average numbers

P

phil access

In the query design, "group by" is set to "sum" or "avg". However, the query
run does not perform the arithmetic function. The result is a table that
changes only the header from amount to sumamount, but lists all the original
data.
Why is the sum function not working?
 
M

Marshall Barton

phil said:
In the query design, "group by" is set to "sum" or "avg". However, the query
run does not perform the arithmetic function. The result is a table that
changes only the header from amount to sumamount, but lists all the original
data.
Why is the sum function not working?
Click to expand...


Without seeing the query, I'll take guess that you are
grouping on too many fields (making each group just a single
record). You should only use Group By on the fields you
want to get a sum for. Get rid of the other fields so they
don't get in the way.
 
Top