How do I total up a column?

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

Guest

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
 
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
 
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]
 
Back
Top