Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
electroniclady
Starting Member
4 Posts |
 Posted - 2005-10-25 : 21:16:33
|
| In MS Access, On a Report:I want a total on a group of records. Whats more, I want to subtotal this group of records, but add the text box to another group's footer. How can I do this?????My current code looks like the following, and it works as long as the text box is on the same group that I'm adding up. But that's not what I want. As I said above, I want my text box on the another group.= "Sub Total: Specialty Seat Type," &[Claimant] &"-->" &[SeatType]BTW, my Grouping is as follows:1st level: Claimant2nd level: Site3rd level: SeatTypeI want to add the total amount of SeatTypes (per Claimant/Site), and show the Sum on the Claimant footer level. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-10-31 : 21:25:14
|
| From this post, it sounds like you just need to "remember" the text when the group subtotal is calculated, but then display it when the next group is calculated - is that what you're after?In this case, calculate the whole string and assign it to a variable in VBA at the first group footer format or paint event. Then update the text box from the variable at the next group footer format or paint event, rather than trying to calculate it on the fly.(see your other post)--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Sum per Group but Display on Another Group