Queries;Calculations

B

BARKAROO

I am having a similar problem as the gentleman below... I have all of my
calculations in the footer of the report - Although I don't want to see the
details, so I changed the properties to invisible, leaving me with numerous
blank pages, when I really only need the totals. The MVP suggested a query,
but I'm fairly new to Access and could use some help. I have some experience
with Queries, but none with calculating totals in queries. Can anyone
provide any assistance?

Thanks.
----------------------------------------
George

If you are only using the "Details" section of your report to do
calculations, consider doing those calculations in a query, instead.

JOPO (just one person's opinion)

Jeff Boyce
<Access MVP>

Have report with computations in detail, but no visible
data.

Want results to show in Group Footer & Report Footer.

When run report I get 70 + blank pages, with data only on
one page.

How do I eleminate blank pages??

Thanks!!!!

George L
 
R

Rick B

To get rid of your blank space, just set your detail objects (and detail
section) to CanShrink=Yes.

Rick B
 
J

John Spencer (MVP)

Well, did you change the detail section's visible property to false. That
should work. Hide the entire section, not the individual controls in the section.

To calculate summary data in a query
--Open the query in design view
--Select View: Totals from the menu. That will add a new row area to your query
and will Set the total to GROUP By for each column.
--Select Sum, or Count, or Avg, or Min, or Max for those columns you wish to
generate that type of value.

That should get you started.
 
Top