obtaining the sums of a query in a report.

[kingz2000]

Hi,

I have an Access Report linked with a query, which gives me figuers several columns. All I would like in addition are the summations of the columns in my report aswell. How do I do that?? I am working with Access2003.
Thanks in advance.

Kingsley

 

[kingz2000]

By the way, I have tried a text box with the Running Sum property set to Over Group, but it doesnt work.

 

[dhookom]

Display the Report Footer and add text boxes with control sources like:

=Sum([MyNumericFieldOrExpression])

You shouldn't have to use any running sums for this.

Duane
Hook'D on Access
MS Access MVP

 

[kingz2000]

hmm...In my detail I have the column1, column2, column3.In my reportfooter I have written '=sum(column1)' for some reason I get an error as sum.
Have I forgotten something?

 

[dhookom]

Are the "column..." fields numeric? When you view them in the datasheet view of the record source are the left or right aligned?

Are you certain you placed the text boxes in the Report footer and not the Page footer?

Duane
Hook'D on Access
MS Access MVP