record count

[Andy G]

What is the easiest way to display the number of records in a report footer?
I tried using RecordsetClone.Count like I do in forms but apparently that is
not available to you in the report world. I tried =Count([myIDfield]) and
got #Error.

Thanks.

 

[Duane Hookom]

Are you sure you placed your text box in the Report Footer and not the Page
Footer?
=Count([myIDfield])
should work in the Report Footer (or Header) as long as the name of the
control is not also the name of a field in the report's record source.

 

[Allen Browne]

Try:
=Count("*")

Make sure the Name of this text box is not the same as a field. Access gets
confused if it has the same name as a field, but is bound to something else.

 

[Andy G]

Ah...it was in my page footer, but that is actually where I want it. So I
put an invisible count box in the report footer and then referecenced that
in my page footer and that worked fine.

Thanks Duane.

Are you sure you placed your text box in the Report Footer and not the
Page Footer?
=Count([myIDfield])
should work in the Report Footer (or Header) as long as the name of the
control is not also the name of a field in the report's record source.

--
Duane Hookom
MS Access MVP

What is the easiest way to display the number of records in a report
footer? I tried using RecordsetClone.Count like I do in forms but
apparently that is not available to you in the report world. I tried
=Count([myIDfield]) and got #Error.

Thanks.

 

[Al Campagna]

Andy,
That calculations should work... as long as myIDField is not a calculated unbound
field.
Also, check that it's in the ReportFooter, not the PageFooter.