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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,304
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
63,304
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,116
Messages
5,835,476
Members
430,358
Latest member
zzc1128

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top