Calculating columns

  • Thread starter Thread starter Taher
  • Start date Start date
T

Taher

Hi there

I have a table and I need to obtain the sum of all of the
values in a particular column. Firstly, how do I
distinguish which column I want to sum up; and secondly,
how do I get the sumation?

Thank you,
Taher
 
try

SELECT Sum(MyFieldName) AS SumOfMyFieldName FROM MyTableName

btw, a "column" is more appropriately called a "field" when talking about an
Access table.

hth
 
Hi there

I have a table and I need to obtain the sum of all of the
values in a particular column. Firstly, how do I
distinguish which column I want to sum up; and secondly,
how do I get the sumation?
Click to expand...

Create a Query based on your table. Select the field (as Tina says,
that's a better name than "column"), and any other fields that you
want to group by if you want subtotals.

Click the Greek Sigma icon (it looks like a sideways M). A new
"Totals" row will appear in the query grid, with Group By as its
default.

Change that to Sum using the dropdown box to sum the field.
 
Back
Top