Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sum(column1) not in detail section!!
- Thread starter kingz2000
- Start date
Hi
I tried this and it seems to work.
1. Create running sum in detail for Column1 called, say SumCol1. It can be hidden, if you wish.
2. Put a text box in the page footer and set the Control Source to =[SumCol1]
This sums for each page, assuming Column1 is a numeric field.
I tried this and it seems to work.
1. Create running sum in detail for Column1 called, say SumCol1. It can be hidden, if you wish.
2. Put a text box in the page footer and set the Control Source to =[SumCol1]
This sums for each page, assuming Column1 is a numeric field.
- Thread starter
- #3
yes,
thats exactly what i did if u read my other thread (2 below). I just can't belief such an important function, necessary in nearly all reports has be tacled in such a manner...terrible...
You see my detail section is quite thin, for presentation purposes. SO Now I have loads of hidden boxes in that section which is so difficult to handle...oh well..
Thanks anyway
thats exactly what i did if u read my other thread (2 below). I just can't belief such an important function, necessary in nearly all reports has be tacled in such a manner...terrible...
You see my detail section is quite thin, for presentation purposes. SO Now I have loads of hidden boxes in that section which is so difficult to handle...oh well..
Thanks anyway
- Status
Similar threads
- Locked
- Question
- Locked
- Question