View Single Post
  #6  
Old May 24th, 2010, 08:24 PM posted to microsoft.public.access.reports
AccessKay
external usenet poster
 
Posts: 106
Default 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]
.