Add remark for count of listed value

C

CLY

I made a report with 6 subreports on it to show the total count of the
variable values of 6 fields in a table. It's briefly illustrated as follows:
Total No. of participant: 50 (Records in the table)
Occupation Category: ( a Field in the table)
Education 15
Medical 23
Business 12
Registration: ( a Field in the table)
Email 18
Phone 12
Other 20
My boss wanted me to include a remark next to the count for the listed
value of each field. This is a last minute change, and is not catered for in
my design. Is there any quick way to satisfy him? I though of putting a
label next to each value, but not all the values will be listed. Could
someone please help.......my deadline is coming up. Big big thanks in
advance.
 
L

Larry Linson

CLY said:
I made a report with 6 subreports on it to show the total count of the
variable values of 6 fields in a table. It's briefly illustrated as
follows:
Total No. of participant: 50 (Records in the table)
Occupation Category: ( a Field in the table)
Education 15
Medical 23
Business 12
Registration: ( a Field in the table)
Email 18
Phone 12
Other 20
My boss wanted me to include a remark next to the count for the listed
value of each field. This is a last minute change, and is not catered for
in
my design. Is there any quick way to satisfy him? I though of putting a
label next to each value, but not all the values will be listed. Could
someone please help.......my deadline is coming up. Big big thanks in
advance.

Will this be a "standard remark" or one entered by someone at runtime? I'm
not certain what you mean by "not all values will be listed". Could you
clarify? With a bit of VB code, you should be able to make an entire line,
including the "remark" disappear if there is no value to report. On the
other hand, if there are multiple categories, it seems useful to me that you
report all three, even if the count/total of some are zero.

Larry Linson
Microsoft Access MVP
 
C

CLY

I don't know what happened, my question got posted for more than once and my
reply to Larry at 8:00pm disappeared.
Larry, the remark will be a standard one for each value. To explain "Not
all values will be listed", e.g for Occupation Category, there may not be any
records of "Medical", so the report will list the counts for "Education" and
"Business" only.
I'm not good at VB codes, please advise how to add the remark for the value
listed respectively. Thank you.
 
L

Larry Linson

CLY said:
I don't know what happened, my question got posted for more than once and
my
reply to Larry at 8:00pm disappeared.
Larry, the remark will be a standard one for each value. To explain "Not
all values will be listed", e.g for Occupation Category, there may not be
any
records of "Medical", so the report will list the counts for "Education"
and
"Business" only.
I'm not good at VB codes, please advise how to add the remark for the
value
listed respectively. Thank you.

I would put the remark in a Table, indexed by the same index as the
Categories, join it in the Query, and set it as the Control Source of a Text
Box. Shouldn't take any VB code at all, if you use a Criteria of >0 for the
Count.

I think it's user-friendly design to show the lines with zero values. But,
if you can use a Criteria as suggested above, those will just not be
included in results returned by the Query that you use as RecordSource of
the Report.

Larry Linson
Microsoft Access MVP
 
C

CLY

It worked. Showing the lines with zero values provides a complete information
on the report. Thanks for the advice.
I'll have a worry free memorial weekend.
Thank you so much, Larry.
 
C

CLY

It worked. Showing the lines with zero values provides a complete information
on the report. Thanks for the advice.
I'll have a worry free memorial weekend.
Thank you so much, Larry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top