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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,518
Office Version
  1. 365
Platform
  1. Windows
a151=countif($a$1:$a$150,"CRM No")
Wrong forum. This is an Access question, not an Excel one.
 

jaycee

Active Member
Joined
Jul 22, 2009
Messages
323

ADVERTISEMENT

Hi Joe,

I have looked at that thread, but it only shows =count(*) which as already stated does not work
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,518
Office Version
  1. 365
Platform
  1. Windows
Quote from Jaycee:
I have looked at that thread, but it only shows =count(*) which as already stated does not work

Quote from my first reply:
Note that it is very important which Section you place this total in to get an accurate result.
So which Section have you placed this total in?
Is there any Grouping on your Report?
 

jaycee

Active Member
Joined
Jul 22, 2009
Messages
323

ADVERTISEMENT

It is in the Page Report
 

jaycee

Active Member
Joined
Jul 22, 2009
Messages
323
The report is grouped by Status then Type

I have tried to add the textbox with =count(*) into every section but to no avail
 

Watch MrExcel Video

Forum statistics

Threads
1,109,540
Messages
5,529,434
Members
409,876
Latest member
Akash Yadav
Top