Calculations in MS Access

[hrbsh97]

Hello,

I have a database that has multiple fields .. one field has numbers in it ..
is there a way to total those numbers?

Thanks!

 

[John W. Vinson]

Hello,

I have a database that has multiple fields .. one field has numbers in it ..
is there a way to total those numbers?

Thanks!

Yes; create a Query based on the table, and change it to a Totals query by
clicking the Greek Sigma icon (looks like a sideways M). If you want just this
one field with a grand total for the entire table, select only the one field
and change the default Group By on the Totals row to Sum; if you want to sum a
subset of the records, change the Group By to WHERE on the fields upon which
you wish to apply criteria. You can also use Group By to calculate subtotals
on subsets of the data.

 

[vbasean]

Hello,

I have a database that has multiple fields .. one field has numbers in it ...
is there a way to total those numbers?

Thanks!

create new query in design view

go to view, totals

add the field you want to total

change the "group by" tag under the field to sum

click on the red exclation point

total