Counting number of records in a report

[jaycee]

I have a report with the following in each record

Status
Type
Ref No
CRM No
Name
Date Rcd
Equipment
Summary

All I want is a total in the footter of how many records in total there are per report.

I have tried to add a text field with =count(*) but this does not even show up in the report.
I have also tried =count([CRM No]) but this just gives the CRM No of the last record.

Any help appreciated

 

[Joe4]

Page Footer is no good. You need to put it in the Report Footer if you want a Grand Total, or a Group Footer if you want a Group Total.

 

[jaycee]

I have the following on my report

Report GHeader
Page Header
Status Header
Type Header
Detail
Page Footer
Report Footer

I have tried to add the =count(*) textbox into all of these but still does not work

 

[Joe4]

I'll try to recreate your situation I my side and see what happens. I just need a little more information from you.

Can you post a small sample of data?
Which Section are the fields you listed in post #1 located in on your Report?

 

[Joe4]

I haven't seen any response to my requests. Were you able to get this figured out?

Note, if you open up the Table or Query that you are basing this Report on, and click on the Report button, it will automatically create a Report for you with a Total Count (in the Report Footer).
If you try this, does it show an accurate count?

If so, you can either investigate how they do it, and try to apply that to your other Report, or you can simply manipulate this Auto Report to create a Report in the format you want (where the Totals part is already done for you).