Average per date

[Pettor]

I didn't described it wel.. Give me 10 minutes to make it more clear.

 

[Pettor]

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]

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]

Amazing, thanks. This is an example for anyone who is interested.

 

[Joe4]

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]

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]

The solution we found does the job but for thousands of records and columns it crashes the pc. Could there be any other alternative?