Wapug
Registered User.
- Local time
- Today, 18:38
- Joined
- Apr 14, 2017
- Messages
- 51
I have a list of accounts in an access table, they may include a line with a debit and a line with a credit or a line with more than one of any entry (like maybe 2 debits and a credit all on the same acct). Im trying to identify the items with account numbers that match, and then return them in my query with the sum of their entries. This would usually be a pivot table but Im in 2013. MS Access.
A-----------------B
321...............-102.50
321...............-302.50
143................602.55
321................405.00
143...............-601.50
547...............-201.00
should return:
A------------------B
321..................0
143..................1.05
A-----------------B
321...............-102.50
321...............-302.50
143................602.55
321................405.00
143...............-601.50
547...............-201.00
should return:
A------------------B
321..................0
143..................1.05
Last edited: