Totals of a field after it is sorted

  • Thread starter Thread starter Anton
  • Start date Start date
A

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
 
Anton said:
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.
Click to expand...


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.
 
Back
Top