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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|