Make a query with the field you want. Then, on the menu bar you will see the Greek Letter E (I dont know what it's called). If you place your mouse over it, it will say "Totals". Click on that. You will see a new line added to the field called Total. Click on the drop down arrow and select Sum.
