|
| 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
February 5th, 2006, 05:35 AM
posted to microsoft.public.access.reports
|
|||
|
|||
Running sum that includes the beginning balance in the first recor
Developing a report that shows credits and debits and balances. Trying to
use running sum to do this. However, I need the first record to include the beginning balance in its total. From then on would be a running sum. I calculate the beginning balace based on the date given. How can I do this? 
|
|
#2
February 5th, 2006, 06:14 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Running sum that includes the beginning balance in the first recor
Assuming you have a running sum in a text box named "txtBalRunSum", could
you use another text box with a control source like: =txtBeginBalance + txtBalRunSum -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Developing a report that shows credits and debits and balances. Trying to use running sum to do this. However, I need the first record to include the beginning balance in its total. From then on would be a running sum. I calculate the beginning balace based on the date given. How can I do this?
|
|
#3
February 6th, 2006, 02:56 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Running sum that includes the beginning balance in the first r
Example:
Beginning Balance (end of the previous month) is calcuated to be $40, Sales Date Debit/Credit Balance 2/1 30 70 2/2 -20 50 2/3 40 90 "Duane Hookom" wrote: Assuming you have a running sum in a text box named "txtBalRunSum", could you use another text box with a control source like: =txtBeginBalance + txtBalRunSum -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Developing a report that shows credits and debits and balances. Trying to use running sum to do this. However, I need the first record to include the beginning balance in its total. From then on would be a running sum. I calculate the beginning balace based on the date given. How can I do this?
|
|
#4
February 6th, 2006, 05:39 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Running sum that includes the beginning balance in the first r
Where is the previous balance calculated? If we don't know if it is a
separate query, subreport, memory variable, field in the report,... how can we be expected to tell you how to use it? -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Example: Beginning Balance (end of the previous month) is calcuated to be $40, Sales Date Debit/Credit Balance 2/1 30 70 2/2 -20 50 2/3 40 90 "Duane Hookom" wrote: Assuming you have a running sum in a text box named "txtBalRunSum", could you use another text box with a control source like: =txtBeginBalance + txtBalRunSum -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Developing a report that shows credits and debits and balances. Trying to use running sum to do this. However, I need the first record to include the beginning balance in its total. From then on would be a running sum. I calculate the beginning balace based on the date given. How can I do this?
|
|
#5
February 6th, 2006, 03:30 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Running sum that includes the beginning balance in the first r
These are reports that show monthly results. Based on the date given, I DSUM
the credits and debits up to the last day of the previous month. I add this DSUM to the Initial Balance to get the Begin Balance. It looks that, as you suggested, I can use running sum: =txtBeginBalance + txtBalRunSum "Duane Hookom" wrote: Where is the previous balance calculated? If we don't know if it is a separate query, subreport, memory variable, field in the report,... how can we be expected to tell you how to use it? -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Example: Beginning Balance (end of the previous month) is calcuated to be $40, Sales Date Debit/Credit Balance 2/1 30 70 2/2 -20 50 2/3 40 90 "Duane Hookom" wrote: Assuming you have a running sum in a text box named "txtBalRunSum", could you use another text box with a control source like: =txtBeginBalance + txtBalRunSum -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Developing a report that shows credits and debits and balances. Trying to use running sum to do this. However, I need the first record to include the beginning balance in its total. From then on would be a running sum. I calculate the beginning balace based on the date given. How can I do this?
|
|
#6
February 6th, 2006, 07:25 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Running sum that includes the beginning balance in the first r
I think you have a grasp of my suggestion. Let us know if it doesn't work.
-- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... These are reports that show monthly results. Based on the date given, I DSUM the credits and debits up to the last day of the previous month. I add this DSUM to the Initial Balance to get the Begin Balance. It looks that, as you suggested, I can use running sum: =txtBeginBalance + txtBalRunSum "Duane Hookom" wrote: Where is the previous balance calculated? If we don't know if it is a separate query, subreport, memory variable, field in the report,... how can we be expected to tell you how to use it? -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Example: Beginning Balance (end of the previous month) is calcuated to be $40, Sales Date Debit/Credit Balance 2/1 30 70 2/2 -20 50 2/3 40 90 "Duane Hookom" wrote: Assuming you have a running sum in a text box named "txtBalRunSum", could you use another text box with a control source like: =txtBeginBalance + txtBalRunSum -- Duane Hookom MS Access MVP -- "jsccorps" wrote in message ... Developing a report that shows credits and debits and balances. Trying to use running sum to do this. However, I need the first record to include the beginning balance in its total. From then on would be a running sum. I calculate the beginning balace based on the date given. How can I do this?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| running balance | Rob | Running & Setting Up Queries | 5 | August 26th, 2004 05:46 PM |
| Running Balance | Shawn | Running & Setting Up Queries | 1 | August 19th, 2004 06:45 PM |
| Looped result | cojohnso | Running & Setting Up Queries | 7 | July 24th, 2004 01:25 AM |
| Running Balance show at top | SharonSmith | Worksheet Functions | 3 | March 25th, 2004 11:09 PM |
| Running balance for cheque book record | Charlie Donohue | Worksheet Functions | 4 | October 1st, 2003 02:37 PM |
Linear Mode
