Sum function

  • Thread starter Thread starter Billy M
  • Start date Start date
B

Billy M

Hi,

I have a query which has a column called amount.

A specific amount is typed into the query and I would like to count the
totals.

Basically a person makes a payment which is recorded in the query and I
would like to count the total that person pays over a period of time.

As you may guess I have limited experience of doing this kind of work - so
any help is appreciated.

Thanks
 
Using Access 2003, make a new query. Bring the table you have to work with.

Click on the summation button on the toolbar to get a new line in the grid,
the line Total.

Bring the field 'customer' or client, or account, in the grid, keep the
proposed GROUP BY

Bring the field with the date of the transaction in the grid, change the
GROUP BY to WHERE, and at the criteria line, type:

BETWEEN 1/1/2005 AND 12/31/2005

as example, to get ONLY the information about year 2005. (You can change the
date as it fits your needs)


Bring the field amount in the grid, change the GROUP BY to SUM.



That's all. You have the SUM for all clients (customers, accounts, whatever)
for the specified period of time.



Vanderghast, Access MVP
 
Back
Top