SUM issue in report

[-Karl]

I'm thinking this might be more for a SQL query than something that a
form can handle but here goes....

My example is this: Say I have a form that has 2 columns, Site & Data
Size, In this report, I have group the results by site. Now I need
to be able to do a SUM of Data Size colum PER Site! The sum feature
will SUM the entire column.

Am I correct in somehow needing to develop a SQL query? I am thinking
that I might need to develop a seperate table for just that reason (To
perform the calcs per site, then hold them in the table to be
referenced by the report)

Thanks for your help...

-Karl

 

[John Spencer]

In a report, all you need to do is add a group footer (or header) and in the
group section, add a control and set the control's source to

=SUM([Data Size])

You can get a grand total for ALL sites by adding a control the report's
report footer and inserting that same expression.

On a form, this is much, much more complex.

If you don't know how to add a Group section to a report post back for
instructions.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[-Karl]

I think I know what you mean by that. I googled for ACCESS GROUP
HEADER for some examples and this seems to be pretty simple:
http://articles.techrepublic.com.com/5100-10878_11-6073861.html

Grouping columns is the easy part. I just need to sit down and look
over how the group header works. If this is as easy as it gets, then
ALRIGHT!!! Thank you so very much!! I was dreading having to do this
my way


Access is so much easier now once you learn it.

 

[-Karl]

That was too easy Thanks a million!