Adding up records in a query

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

Guest

I want to add up all the records in a query or report. I.e., the total
number hours a certain employee has worked. I only want to add up the one
column. How do I do this in a query? Should it be done in a report instead?
 
I want to add up all the records in a query or report. I.e., the total
number hours a certain employee has worked. I only want to add up the one
column. How do I do this in a query? Should it be done in a report instead?
Click to expand...

It's simplest in a Report. Put a textbox in the Report Footer (or a
Group Footer if you're grouping by employee or some other field). Set
its Control Source property to

=Sum([fieldname])

John W. Vinson[MVP]
 
make sure the fields that you are wanting to add up are number fields in the
table first. They have to be numeric to add up. and yes the totals need to
be done at the report level. you can use the wizard to help you to create
the totals.
 
Back
Top