Average per date

Pettor

Board Regular
Joined
Aug 8, 2015
Messages
152
I didn't described it wel.. Give me 10 minutes to make it more clear.
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Pettor

Board Regular
Joined
Aug 8, 2015
Messages
152
Hello guys,

I have a master table with many clients' transactions per date. What I would like is to have the sum of their transaction per date but for every day that goes by I want to have the total sum of the previous dates.
How could I do that?

So I want to go from this:
1/1/2020​
Client A
2​
1/1/2020​
Client B
4​
1/2/2020​
Client A
3,5​
1/2/2020​
Client B
0,5​

To this:
1/1/2020​
Client A
2​
1/1/2020​
Client B
4​
1/2/2020​
Client A
5,5​
1/2/2020​
Client B
4,5​

Thanks
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,901
Office Version
  1. 365
Platform
  1. Windows
Looks like you want a running sum per client. The only way I know of how this could be done is with a report. A report can give you a running sum over a field, but a form cannot. Your report would have to group detail records by client and the running sum would have to be applied over the group(s). Pretty sure you could not do that if you group by date or any other field. Maybe research "MS Access report running sum over group" and see if that applies or helps.
 

Pettor

Board Regular
Joined
Aug 8, 2015
Messages
152
Amazing, thanks. This is an example for anyone who is interested.

 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,405
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

I am locking your old thread (Date filter in query).
As per forum rules, in the future please continue on in the SAME thread, instead of starting a new one on the same topic.
 

Pettor

Board Regular
Joined
Aug 8, 2015
Messages
152
Sorry Joe, I thought it was a different subject. The problem is that we can not delete a post that may not be necessary.
 

Pettor

Board Regular
Joined
Aug 8, 2015
Messages
152
The solution we found does the job but for thousands of records and columns it crashes the pc. Could there be any other alternative?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,536
Messages
5,523,421
Members
409,522
Latest member
AbdulAli

This Week's Hot Topics

Top