If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
TOTALLING A COLUMN
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? -- |
#2
|
|||
|
|||
TOTALLING A COLUMN
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. -- Rick B "Pat" wrote in message ... 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? -- |
#3
|
|||
|
|||
TOTALLING A COLUMN
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. |
#4
|
|||
|
|||
TOTALLING A COLUMN
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. -- Rick B "Betty Tiska" wrote in message ... 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. |
#5
|
|||
|
|||
TOTALLING A COLUMN
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. -- Thanks, Pat "Rick B" wrote: 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. -- Rick B "Betty Tiska" wrote in message ... 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. |
#6
|
|||
|
|||
TOTALLING A COLUMN
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. -- Rick B "Pat" wrote in message ... 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. -- Thanks, Pat "Rick B" wrote: 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. -- Rick B "Betty Tiska" wrote in message ... 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. |
#7
|
|||
|
|||
TOTALLING A COLUMN
"Rick B" wrote: 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. -- Rick B "Betty Tiska" wrote in message ... 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. Mea culpa, Rick! I realized that I was in the Access group just as I was sending . . . and a millisecond too late to retract. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Running total w/2 columns - Excel | RagDyeR | Worksheet Functions | 2 | August 10th, 2005 04:28 PM |
match and count words | David | Worksheet Functions | 5 | July 4th, 2005 02:24 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Using Validation to force entry into cells? | Mark | General Discussion | 16 | October 27th, 2004 09:23 PM |