Clicking Totals in the Ribbon adds a Totals record in the query designer. You can then specify how each field will use the total.