Prev: Complex Count function with a condition
Next: bread association between label and text box
From: AccessKay on 24 May 2010 12:49
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!

From: Marshall Barton on 24 May 2010 13:07
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]
From: Duane Hookom on 24 May 2010 14:18
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?


"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!
>
From: AccessKay on 24 May 2010 14:53
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/Forums/en-US/addbuz/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!
> >
From: AccessKay on 24 May 2010 15:24
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]
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Complex Count function with a condition
Next: bread association between label and text box