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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top