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]

See here: Counting in reports - Access
Note that it is very important which Section you place this total in to get an accurate result.

 

[Oeldere]

a151=countif($a$1:$a$150,"CRM No")

 

[Joe4]

a151=countif($a$1:$a$150,"CRM No")

Wrong forum. This is an Access question, not an Excel one.

 

[jaycee]

Hi Joe,

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

 

[Joe4]

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]

It is in the Page Report

 

[jaycee]

Sorry the Page Footer

 

[jaycee]

Have also tried it in the report footer

 

[jaycee]

The report is grouped by Status then Type

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