Grouping Count - Text Change

[Brent Stephens]

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.

 

[Marshall Barton]

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.