Oh No! No Pivot! (1 Viewer)

Wapug

Registered User.
Local time
Today, 06:15
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
 
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Today, 03:15
Joined
Oct 29, 2018
Messages
21,358
Hi. Have you tried a simple Totals query? For example:
Code:
SELECT [A], Sum([B]) AS Total FROM TableName GROUP BY [A]
 

Wapug

Registered User.
Local time
Today, 06:15
Joined
Apr 14, 2017
Messages
51
Thank you for helping
 

Wapug

Registered User.
Local time
Today, 06:15
Joined
Apr 14, 2017
Messages
51
It did, and I was a little embarrassed that it was something I should have known.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:15
Joined
Oct 29, 2018
Messages
21,358
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.
 

Users who are viewing this thread

Top Bottom