Totaling fields

D

David

Hello everyone. Is it possible for Access 2002 to total fields in a query
when it's written in design view. For example: If I pull data from 2 fields
(Customer name and payment amount) how can I have it total the payment
amount? Does this have to be done through a report or can I do it within the
query?
 
J

John Spencer MVP

To turn it into a query where you get totals
-- SELECT View: Totals from the menu
-- Change GROUP BY to SUM under the Payment field

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Invoices outstanding at end of year 1
Question about Reports and Tables 2
Selection of records from subform to lock and further processing in access 2007 0
Access Query problem 1
Totaling Multiple Subreports 5
Over my head in Access 2
Need help changing a database 5

Top