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!

 

[Marshall Barton]

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

 

[Marshall Barton]

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

I don't understand, both Duane and I had a space at the end
inside of the quotes.

 

[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.

 

[AccessKay via AccessMonster.com]

To note...there are some funky time lapses with the newsgroup. I don't know
if this happens to just me but I've started to check the access monster
website along with the newsgroup. But today, I was just looking at the
newsgroup and Duane's reply came in first. After I got your reply, I then
noticed the spaces but did go back and check Duane's reply and noticed he had
spaces also. It just stood out more with yours and then that answered my
question to Duane. So no need for Duane to respond.

But back to that time laspse...on the access monster, you're reply was one
whole hour before Duane's reply. Just thought I'd mentioned this since I
have lots of experience on the waiting side.

Anyways...I'm thankful for the help whenever it makes it to me.

 

[Marshall Barton]

To note...there are some funky time lapses with the newsgroup. I don't know
if this happens to just me but I've started to check the access monster
website along with the newsgroup. But today, I was just looking at the
newsgroup and Duane's reply came in first. After I got your reply, I then
noticed the spaces but did go back and check Duane's reply and noticed he had
spaces also. It just stood out more with yours and then that answered my
question to Duane. So no need for Duane to respond.

But back to that time laspse...on the access monster, you're reply was one
whole hour before Duane's reply. Just thought I'd mentioned this since I
have lots of experience on the waiting side.

That's the way news groups work. Each news server receives
a post from anyone connected to it and then forwards them on
to other news servers. So, it all depends on where you are
in the internet, how loaded each server at the time and
what's connected to what.

I have seen some posts take many hours to work their way
around the world while others appear to be near
instantaneous.