How to sum quantities per group

[crcastilla]

Okay, this is probably more easy than what I think but here is my explanation and my question.



Let's say I have a table with information like this:

Number Quantity Date
1 20 XXX
2 12 XXX
2 65 XXX
1 6 XXX
4 13 XXX
5 32 XXX
3 41 XXX
4 22 XXX

Now, Let's say I want a report as shown below..


Number

1 Total= 26
2 Total= 77
3 Total= 41
4 Total= 35


Well, by now I'm sure you get the point. I want it to add all the quantities with their respective numbers and only show the total on the report.

How would I do this?

Thank you.

[orange]

INvestigate aggregate query Sum and Group By

http://www.w3schools.com/sql/sql_functions.asp
http://www.w3schools.com/sql/sql_groupby.asp

[pbaldy]

I changed your thread title to something more meaningful to future users.