Put a total at the bottom a column

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

Guest

I have a column for travel time in a table. I would like the column to have
a total for travel time at the bottom of the query results. I Thought using
the totals button would do it, but I guess not. Can you please help?

Thanks, Edward Keith
 
edward said:
I have a column for travel time in a table. I would like the column
to have a total for travel time at the bottom of the query results.
I Thought using the totals button would do it, but I guess not. Can
you please help?

Thanks, Edward Keith
Click to expand...

Access is not a spreadsheet. You can put a total on a form or report, but not
in a table.
 
Are you working in Word? If so, place cursor in the cell where you want the
total to appear, select "table" from the menu, then "formula." Type in
SUM(ABOVE) after the = sign (no spaces — see below). If you're totaling a
row, substitute (LEFT) for the (ABOVE) or whatever direction you desire to
total.

=SUM(ABOVE)
 
Back
Top