A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Label for totals in group footer



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2010, 05:49 PM posted to microsoft.public.access.reports
AccessKay
external usenet poster
 
Posts: 106
Default Label for totals in group footer

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!

  #2  
Old May 24th, 2010, 06:07 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Label for totals in group footer

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]
  #3  
Old May 24th, 2010, 07:18 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Label for totals in group footer

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!

  #4  
Old May 24th, 2010, 07:23 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Label for totals in group footer

AccessKay wrote:

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.
--
Marsh
MVP [MS Access]
  #5  
Old May 24th, 2010, 07:53 PM posted to microsoft.public.access.reports
AccessKay
external usenet poster
 
Posts: 106
Default Label for totals in group footer

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!

  #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]
.

  #7  
Old May 24th, 2010, 09:07 PM posted to microsoft.public.access.reports
AccessKay via AccessMonster.com
external usenet poster
 
Posts: 22
Default Label for totals in group footer

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 wrote:
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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201005/1

  #8  
Old May 24th, 2010, 11:24 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Label for totals in group footer

AccessKay via AccessMonster.com wrote:
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.

--
Marsh
MVP [MS Access]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.