Can you do a "sumall" for a column in access?

[dwhsiberia]

I'm making a data base in access for work right now. I'm trying to make a
"sumall" command for one of my columns (as you would in Excel), but can't
figure out how to do it. Does anyone have any ideas?

 

[KARL DEWEY]

Search on DSum.

 

[Albert D. Kallal]

Access is a database system, and therefore tends to work a little bit
different than how you do things in excel.
(in fact things work VERY differnt

The most common way of course is to put a sum in the footer of a report.

However if you have an invoicing type system, or simply need to sum up
column in access you need to build a form. If you looking for rows and
collums, then you built a continoues form (what the wizard calls tabular
layout)

You then simply place a text box in that forms footer

We can call the text box MySum

For the data source of that text box, simply place the following exprssion

=Sum([Name of collum to sum])

You can see a screen shot of this in an actual applciaton here

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Scroll down to the "last" screen shot, and not the "sum" total at the bottom
of the form on the right side.

 

[Jeff Boyce]

Are you trying to do this directly in the table?

If so, as other responders have pointed out, Access is not a spreadsheet.
Don't expect to be able to do the same things, the same ways, and don't
expect to be able to "feed" it the same data structures, if you want to gain
the benefits of Access' features/functions.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP