Running Total with multiple fields

Jodi_MHS

New member
Local time
Today, 14:38
Joined
Dec 6, 2001
Messages
8
I created a form in my DB that has several fields for dollar entry. There are 23 fields for each category, and 5 categories. Each category is on a tab. I set up running totals on the individual tab pages. Each tab page is divided into 6 rows. My running totals go across the tab pages. So, each of the 6 rows is added up. This works great! I want a total for each page though. I created an expression that sums the row subtotals. This resulted in an error in the field and all the other subtotal fields. I also tried to create a formula that summed the 23 fields. This also did not work. What can I do to create this Total for each tab page??? Also, I will need to create a sum for the total of all 5 pages. This creates a similar problem. I do not know VB...so how can I get through this without it? Your help is appreciated!
smile.gif
 

Users who are viewing this thread

Back
Top Bottom