Hi,
    I"m new to this.  This is my first post.  I have a report that is
grouping on membercode.  The member code can contain the following values:
'01', '02', '03', and '04'.   Now, I have the report grouping on membercode,
which breaks them into their individual values fine.  However, each value
represents something different, so I want the Count I'm doing in the group
footer to represent what each value does.  What is mean is, I wan to count
the # of

'01' - Temporary Members
'02' - Members in Good Standing
'03' - Members owing dues
'04' - Retired Members

I currently just have one count with no Description text, but I want to have
a description test for each break.  How can I do this?  I hope this makes
sense.

My report currently looks like this:

01
01
01
01
   04

02
02
02
   03

03
  01

04
04
04
04
04
   05

As you can see, it counts each row in the group, but I don't know how to
differentiate the description text for each one.  Thanks.

Brent Stephens wrote:
> I have a report that is
>grouping on membercode.  The member code can contain the following values:
>'01', '02', '03', and '04'.   Now, I have the report grouping on membercode,
>which breaks them into their individual values fine.  However, each value
>represents something different, so I want the Count I'm doing in the group
>footer to represent what each value does.  What is mean is, I wan to count
>the # of
>
>'01' - Temporary Members
>'02' - Members in Good Standing
>'03' - Members owing dues
>'04' - Retired Members
>
>I currently just have one count with no Description text, but I want to have
>a description test for each break.  How can I do this?  I hope this makes
>sense.
>
>My report currently looks like this:
>
>01
>01
>01
>01
>   04
>
>02
>02
>02
>   03
>
>03
>  01
>
>04
>04
>04
>04
>04
>   05
>
>As you can see, it counts each row in the group, but I don't know how to
>differentiate the description text for each one.  Thanks.


You want the group footer to say something like:
	5 Retired Members

The "right" way to so this is to use another table that has
fields for membercode and descriprion.  Then you can use a
query to Join that table to the one you're using now and
make the description availble to the report.

-- 
Marsh
MVP [MS Access]