Summary Page/Totals

[Donny]

I would like to know the best way to create 1 summary page in a report that I
can manipulate all my data from the entire database. I've tried bringing the
information in the Detail part of the report and hiding it, then using Totals
in the Footer Section. I ended up with 50+ empty pages with the totals on the
last page. I have Queries allready set-up. Can someone please tell me the
logical way to approach this. Right now I'm exporting to Excel to accomplish
this.
Fairly New User,
Thanks in advance

 

[Marshall Barton]

I would like to know the best way to create 1 summary page in a report that I
can manipulate all my data from the entire database. I've tried bringing the
information in the Detail part of the report and hiding it, then using Totals
in the Footer Section. I ended up with 50+ empty pages with the totals on the
last page. I have Queries allready set-up. Can someone please tell me the
logical way to approach this. Right now I'm exporting to Excel to accomplish
this.

If the report's record source query can calculate the
totals, it would be the "best" way. There are almost no
situations where this can not done.

If you really have one of the odd situations or you are not
up to that kind of query, then you can do what you want by
making the detail section invisible. You nay also need to
make sure the ForceNewPage property is not set.

 

[Donny]

Thanks, I will start there.

If the report's record source query can calculate the
totals, it would be the "best" way. There are almost no
situations where this can not done.

If you really have one of the odd situations or you are not
up to that kind of query, then you can do what you want by
making the detail section invisible. You nay also need to
make sure the ForceNewPage property is not set.