Hello all,

Another one for you. I've got a crosstab query running with depots on the left and months of the year across the top. Row totals are easy but I want to add column totals at the bottom of the report.

I've tried adding a field in the page footer and the report footer and declaring it to be a running sum but nothing seems to work.

Any advice?

Thanks
Stu:D

Try this in the report footer:

=Sum(FieldName)

Thats got it - Simple when you know how.

thanks :D

No problemo, glad it worked for you.

I have a similar issue and was wondering how can I then present the results in a graph. Doesn't the graph need a control source run by a query?