Running Sum problem

  • Thread starter Thread starter Rebeca
  • Start date Start date
R

Rebeca

I have a report that pulls all of it's data from a query from multiple
tables. The report itself works beautifully with the running sum appearing
correctly on the preview. When I go to print it, the running sum is skewed. I
am using the on print option which from what I now understand is unreliable.

What I am trying to do is take a Beginning AR balance and subtract daily
entries (which are grouped by date). I have tried and tried using the
runningsum options and they do not seem to work properly for me. It always
wants to add the beginning balance again at each group change.I'm not exactly
sure what I am doing wrong.

Also along these same lines, how do I then make the ending AR balance the
next month's beginning balance? Any help would be appreciated.
Thanks!
 
If I understand correctly, you might be able to place a text box [txtARBB]
with the beginning AR Balance in the report header. Then create an invisible
running sum text box [txtARRS] in the detail section (or other). Then use a
visible text box in the detail section with a control source of:
=txtARBB + txtARRS
The plus might need to be changed to minus depending on your data.
 
If I understand correctly, you might be able to place a text box [txtARBB]
with the beginning AR Balance in the report header. Then create an invisible
running sum text box [txtARRS] in the detail section (or other). Then usea
visible text box in the detail section with a control source of:
  =txtARBB + txtARRS
The plus might need to be changed to minus depending on your data.
--
Duane Hookom
Microsoft Access MVP



Rebeca said:
I have a report that pulls all of it's data from a query from multiple
tables. The report itself works beautifully with the running sum appearing
correctly on the preview. When I go to print it, the running sum is skewed. I
am using the on print option which from what I now understand is unreliable.
Click to expand...
What I am trying to do is take a Beginning AR balance and subtract daily
entries (which are grouped by date). I have tried and tried using the
runningsum options and they do not seem to work properly for me. It always
wants to add the beginning balance again at each group change.I'm not exactly
sure what I am doing wrong.
Click to expand...
Also along these same lines, how do I then make the ending AR balance the
next month's beginning balance? Any help would be appreciated.
Thanks!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

worked perfectly, thank you. I was obviously making it harder than it
needed to be. Now to figure out my other problem, I'll repost in the
queries section as I'm assuming it will be an update or delete query
that would do this.
 
Back
Top