How do I total up a column?

G

Gina

I would like to find out how I can create a "total or a sum" at the bottom of
a list of numbers in a column - I know in Excel you can create a formula to
total a column of numbers in a particular cell but I can't figure out if I
can do that in Access
 
K

KAnoe

I use this =Count([Field]). Needs to be on the report footer or header.

Also you can use the Report wizard and and than look at the code.

Hope this helps Gina.

Keith
 
J

John Vinson

I would like to find out how I can create a "total or a sum" at the bottom of
a list of numbers in a column - I know in Excel you can create a formula to
total a column of numbers in a particular cell but I can't figure out if I
can do that in Access
Click to expand...

Excel is a spreadsheet. Access isn't. THEY ARE DIFFERENT!

If you want to see this total on a Form or Report, make the Form (or
Report, or Report Section) footer visible and put a textbox into it
with a control source

=Sum([fieldname])

in the footer.

If you just want the sums, use a Totals Query based on your table. A
Query cannot (well, not easily) have the individual rows and also the
sum - do it as two separate queries if you need to see both.

John W. Vinson[MVP]
 
Top