Adding up records in a query

[predwine]

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?

 

[John Vinson]

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?

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]

 

[debra turner]

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.