formula to add up same po# previous and current payment?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

foreigner - 12 Oct 2005 22:23 GMT

I have many payments some with po#, some without it, I need to add up the
previous payment on the same po with the current one, what is the formula or
expression?

Reply to this Message

Arvin Meyer [MVP] - 13 Oct 2005 03:14 GMT

> I have many payments some with po#, some without it, I need to add up the
> previous payment on the same po with the current one, what is the formula or
> expression?

In a query, something like:

SELECT PONum, Sum(Payment) AS TotalPayment
FROM MyTable
GROUP BY PONum;

Substitute you table and field names and paste this in the SQL window of
your query.

Signature

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Reply to this Message