Total a Column

[Lawson&Stolfus]

Hello,

Please help. I have been told that in a query you can total a column, but I can not seem to figure out how to do it. I know how to total records (left to right), but not a column (top to bottom). I have one column that has dollar amounts on each record and I need a total of them. Can someone explain how to accomplish this?

Char

 

[Nirious]

=Sum(TableName!TableColumnName) should do it

 

[Lawson&Stolfus]

Nirious

Thank you for the help. Where should I do this formula? I have two tables in a query. This was so I could creat a column that would include the amounts in a column that I need totoled. So I assume I must do it in the query so how and/or where do I do it? What line. Please advise.

 

[Nirious]

You can't do it in your query itself, because it is an aggregate function(like, sum, avg or max), meaning, it operates on columns rather than on rows.

You can make a new query that holds the value, or you can put it into the controlsource property of a textbox as an expression.

I have added an example for you to look at.

The upper part is with the expression, the lower part is with the extra query