easy total column question!

[firthk]

This is probably really easy - i have created a report from a query and i would like a total of one column? do i create a text box in the footer & use control source to build an expression using "sum" ? because it dosnt seem to work - if anyone could give the expression i would be extremly grateful?
thanks

 

[firthk]

well progress is being made, i think - I have the total field working but it willonly work in the "detail" if i put it in the footer it doesnt work ?? in the detail it replicates itself after each record?
is there a way of positiioning at the end of the column (in the detail) but only once? ie

5
6
7
7
7

32

 

[Rich]

Article ID: Q132017

 

[firthk]

many thanks - problem solved - i created an invisible field in the detail that totals the column then pulled that value into a new text field in the footer