Queries;Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
To get rid of your blank space, just set your detail objects (and detail
section) to CanShrink=Yes.

Rick B
 
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.
 
Back
Top