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

Thanks again.

"Duane Hookom" wrote:

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/...ddbuz/threads?


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