Totals of a field after it is sorted

[Anton]

Hii Guys I have tried to see if there is already this situation but i have
gave up .
here is the prob i have .

I have a table with a lot of data, i would like to issue a report that will
group ie not report each record but give me totals by a specific field . I
hope i explained myself clearly.

Anton

 

[Marshall Barton]

Hii Guys I have tried to see if there is already this situation but i have
gave up .
here is the prob i have .

I have a table with a lot of data, i would like to issue a report that will
group ie not report each record but give me totals by a specific field . I
hope i explained myself clearly.

The first thing to do when creating a report is to create a
query that retrieves and calculates the values you want to
see in the report. In this case, I think you can just use a
Totals type query that groups by the specific field(s?) and
uses Count or Sum for the fields you want to total.

Once you have the query set up properly, the report should
be easy.