Sum function

[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

 

[Michel Walsh]

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

 

[MGFoster]

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.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You have to create a SUM, not a COUNT of the amount. Click the Group By
icon on the query tool bar (it's the Greek letter Epsilon - a fancy E).
In the Amount column select SUM in the Total row.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSdEPlIechKqOuFEgEQKZtwCfZSnNYIeTFyk36T4BRRN+hoG7PpoAoMWK
vTIr2VLdcfvhPHjVcUpYsiFe
=Knwv
-----END PGP SIGNATURE-----