Totalling and Viewing Values in Report Footer

[nutmeg]

Hello,

I have a report based on categories i.e. Appointment Booked; To be
Completed; Completed etc. I have totalled each group in a footer based on
the category.

=Count([FieldCat])

I would like to then transfer each category count to the bottom of the
report i.e. if there are 18 records in Appointments Booked and 20 To be
Completed, I would like lines on the bottom of the report footer that show
them down there i.e.

Appointments Booked = 18
To Be Completed = 20

I have tried several ways but nothing seems to give me the value of each
count grouping. Can anyone advise me how to show these the way I would like
to.

Thank you,

 

[Duane Hookom]

Create a subreport based on a totals query that groups by categories and
counts. Place the subreport in your report's Report Footer section.

 

[nutmeg]

Okay. I didn't think of that. I was looking at something like a "Value = ".
I thought that I could use something like this and it would report.

=FieldCat.Value = "Appointment Booked"

But if not, I'll give this subreport a try. Thank you for taking the time
to respond. I appreciate it. May I ask then, when can you use the ".Value"?
What situation would it work in?

Thanks,

Create a subreport based on a totals query that groups by categories and
counts. Place the subreport in your report's Report Footer section.
--
Duane Hookom
Microsoft Access MVP

Hello,

I have a report based on categories i.e. Appointment Booked; To be
Completed; Completed etc. I have totalled each group in a footer based on
the category.

=Count([FieldCat])

I would like to then transfer each category count to the bottom of the
report i.e. if there are 18 records in Appointments Booked and 20 To be
Completed, I would like lines on the bottom of the report footer that show
them down there i.e.

Appointments Booked = 18
To Be Completed = 20

I have tried several ways but nothing seems to give me the value of each
count grouping. Can anyone advise me how to show these the way I would like
to.

Thank you,

 

[Duane Hookom]

The subreport will be self-maintaining if/when you add categories. You could
add a bunch of text boxes with control sources like:

="Appointments Booked: " & Sum(Abs([Category]="Appointment Booked"))
However, if you change your categories, you will have to maintain your
controls. A subreport won't require further modification.

--
Duane Hookom
Microsoft Access MVP

Okay. I didn't think of that. I was looking at something like a "Value = ".
I thought that I could use something like this and it would report.

=FieldCat.Value = "Appointment Booked"

But if not, I'll give this subreport a try. Thank you for taking the time
to respond. I appreciate it. May I ask then, when can you use the ".Value"?
What situation would it work in?

Thanks,

Create a subreport based on a totals query that groups by categories and
counts. Place the subreport in your report's Report Footer section.
--
Duane Hookom
Microsoft Access MVP

Hello,

I have a report based on categories i.e. Appointment Booked; To be
Completed; Completed etc. I have totalled each group in a footer based on
the category.

=Count([FieldCat])

I would like to then transfer each category count to the bottom of the
report i.e. if there are 18 records in Appointments Booked and 20 To be
Completed, I would like lines on the bottom of the report footer that show
them down there i.e.

Appointments Booked = 18
To Be Completed = 20

I have tried several ways but nothing seems to give me the value of each
count grouping. Can anyone advise me how to show these the way I would like
to.

Thank you,