TOTALLING A COLUMN

P

Pat

I have a table and added a column for Staff Bonuses. I wanted a sum of the
entries made in the column so that I can cross check that the total is what I
anticipated it would be. Can this be done on this table?

--
 
R

Rick B

You seem to be trying to use Access as a spreadsheet. If you want a
spreadsheet, try Excel.

You can total the entries, but you don't do so in the table. Once you build
the table definitions, you should not work in the table. You should add
records through a form. To total items, you should create a query, report,
or form. A report would make the most sense for what you are doing. I
think the report wizard will even walk you right through what you want.

But, if you are simply creating a spreadsheet, then use the correct tool -
Excel.

Good Luck.
 
B

Betty Tiska

Yes you can (but only in a table). To make it easy, right click on the Word
toolbar (at the top of your screen). Hit Customize; then go to Table, then
Commands, then left click the AutoSum button (it's the Sigma sign and looks
like a capital E). Drag the AutoSum button up to the Standard toolbar with
the left mouse button and leave it up there by releasing the mouse button.
After entering numbers in a column, click the empty space at the bottom of
the column and hit the AutoSum button that is now on your Standard toolbar -
there is your total! When prompted to "save to the Normal Template" when
closing, click Yes; that will keep the AutoSum sign on yout toolbar.
 
R

Rick B

Ummmm - Betty. This is an ACCESS newsgroup. You do not appear to be
answering an ACCESS question. Are you using Word or Excel? We assume
posters here are using the database application, Microsoft ACCESS.
 
P

Pat

Thank you I was thinking the same. I do have an ACCESS table for which I
wanted to sum a column. Perhaps I can pull a query and sum the column that
way.
 
R

Rick B

Yes. A query, form, or report would be your best bet for this. Personally,
I would use a form or report. I'm not sure you can show details AND a total
in one query, but I could be wrong.
 
B

Betty Tiska

Rick B said:
Ummmm - Betty. This is an ACCESS newsgroup. You do not appear to be
answering an ACCESS question. Are you using Word or Excel? We assume
posters here are using the database application, Microsoft ACCESS.
Click to expand...



Mea culpa, Rick! I realized that I was in the Access group just as I was
sending . . . and a millisecond too late to retract.
 
Top