repeat all group footers in report footer

[Judy]

Is there a way to reprint the group footers in the report footer of an
access report. Plan B is to design a subreport.

Thanks,
Judy

 

[Duane Hookom]

Use a subreport bound to a totals query.

 

[Judy]

Thanks Duane -The only problem with that is that some of the control
sources are loaded on report open, which works great in the main
report, but you can't do in a subreport or at least I can't in this
case because there are so many if statements before the setting the
control source. I have used the code to show that it the first time it
is being loaded in other cases, but apparently the if statements cause
a timing issue. Do you know another path I can try?

Thanks,
Judy

 

[Duane Hookom]

Maybe create a temporary table to use as a record source for a subreport.
Rather than lots of "if statements" and "setting the control source", I will
often populate a temporary table for reporting.

 

[Judy]

Thanks Duane. By temporary table, does that mean a table you set up
like a regular table and use to store calculated data, or is that an
Access term I've never heard before?
Judy

 

[Duane Hookom]

You are correct. You create standard tables (maybe using a make table query)
and base your report on these. You may need to use code to modify values or
whatever. I generally have report tables created and then prior to running a
report, I delete all the records in the table and then append the records I
want in the report.

 

[Judy]

Thanks for all your help. This was exactly what I needed to do. Judy