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

F

foreigner

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?
 
A

Arvin Meyer [MVP]

foreigner said:
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?
Click to expand...

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.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top