sum or average numbers

[Guest]

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?

 

[Guest]

It could be that one of the fields that listed in the query have a unique
value that still list all the records, and doesnt let you group by the query.
e.g date field, a key field.

A common mistake when people creating a group by query is, if you mark a
field to not to be display, because it just been used for a filter, it's not
enough, you need to change it from group by to where.