Quantity total on a report

[dzisaacs]

I have a report like this, it's pretty simple

Person
Person_id Name Quantity
1 Maria 3
2 Daniel 2

The only thing i want to add and i dont' know how, it's the sum of all the quantities at the end of the report...does someone knows how to do that?

example of what i want the report to look like:

Person
Person_id Name Quantity
1 Maria 3
2 Daniel 2
5 -> which is the total

I really appreciate your time helping me, i just need that result in the report and i'll be fine

 

[scriverb]

In the Report Footer for the report create a control that has a Control Source like this:

=Sum([quantity])

You may want to also add a Format function to this aggregate value for display purposes. Post back if you have any questions.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]