Show totals at bottom of report.

[melvis]

Hiya,

I'm having a bit of trouble showing the totals at the bottom of a report. I have tried setting the control source to

=Count(*)

but the message in the text box displays

#Error

Doe's anybody know what I'm doing wrong?

Any help would be greatly appreciated.

Thanks

 

[ColinEssex]

Hi

If you're doing a sort of "grand total" of a field, the syntax is

=Sum([FieldName])

Hope this helps

Col

 

[melvis]

Thanks for the advice Colin.

It has worked on one of the forms, but not the other.

Basically the report shows information relating to clients details, (as defined in the query). I'm trying to include a text box on the report that will display the number of records in the report. So for instance, if there is 7 clients details displayed, the text box will display 7.

If you could think of anything else I would be grateful, it's starting to annoy me big time!!

 

[Rich]

What do you mean by the bottom of the report?

 

[SaraMegan]

Hi!

I had this problem a while ago, and it turned out I was putting the calculation in the wrong spot. Are you putting it in the report footer or the page footer? I don't think it'll work in the page footer, but it should work in the report footer.

Hopefully that's helpful.

--Sara

 

[melvis]

Basically on the page footer.

 

[SaraMegan]

Try it in the report footer.

 

[melvis]

Thanks Sara,

Worked first time.