Label for totals in group footer

[AccessKay]

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. Can anyone help me with this?
Thank you!

 

[AccessKay]

Thanks...this is what I needed except that I need a space between the part in
quotes and my field Category.

Thanks again.

Use a text box with a control source like:
="Relates to " & [Category Field Name]

--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads?

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. Can anyone help me with this?
Thank you!

 

[AccessKay]

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.