Counting number of records in a report

jaycee

Active Member
Joined
Jul 22, 2009
Messages
323
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,844
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

jaycee

Active Member
Joined
Jul 22, 2009
Messages
323
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,844
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,844
Office Version
  1. 365
Platform
  1. Windows
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,114,117
Messages
5,546,038
Members
410,721
Latest member
adi772
Top