Running Sum problem

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!
 
D

Duane Hookom

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.
 
R

rebeca

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.
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!- Hide quoted text -

- Show quoted text -

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top