Adding quantities in a query

[emshim]

I have a field, quantity, which i want to add all the quantities together to show a total. I want to do this using a query as i will use this total for other calculations. When in the query, i have selected "sum" in the totals column in the quantity. What do i need to do extra? I am not getting any results at the moment.

Emily

 

[emshim]

Its ok guys i worked it out, thanks anyway!

em

 

[rhett7660]

What was the solution?