Label for totals in group footer
Thanks Marshall. I left the "Me." out after trying it and also reading
Duane's response. I did notice that you left some spaces before the second
quote which answers my question of how do I get a space between the quotes
and the field.
Thanks to both of you. I really appreciate the help.
"Marshall Barton" wrote:
AccessKay wrote:
I have a group header in my report called “Category” that contains two
categories. I also have a group footer for category that contains my
sum/totals. I want to add a label beside the totals in the group footer that
relates to the category. How do I do this? I assume I need some type of
expression.
Use a text box with an expresion something like:
="Total for category " & Me.categoryfield
--
Marsh
MVP [MS Access]
.
|