Calculating columns

[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

 

[tina]

try

SELECT Sum(MyFieldName) AS SumOfMyFieldName FROM MyTableName

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

hth

 

[John Vinson]

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?

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.