Oh No! No Pivot!

[Wapug]

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

 

[theDBguy]

Hi. Have you tried a simple Totals query? For example:

SELECT [A], Sum([B]) AS Total FROM TableName GROUP BY [A]

 

[Wapug]

Thank you for helping

 

[theDBguy]

Thank you for helping

Hi. You're welcome! Did it work?

 

[Wapug]

It did, and I was a little embarrassed that it was something I should have known.

 

[theDBguy]

It did, and I was a little embarrassed that it was something I should have known.

Hi. No need. We all forget things sometimes. Part of life and all that. Good luck with your project.