If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running Sum problem
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! |
#2
|
|||
|
|||
Running Sum problem
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. -- Duane Hookom Microsoft Access MVP "Rebeca" wrote: 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! |
#3
|
|||
|
|||
Running Sum problem
On Aug 7, 4:56*pm, Duane Hookom
wrote: 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. -- Duane Hookom Microsoft Access MVP "Rebeca" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|