record count

I receive an error 3464 when I put =count(*) in the controlsource of a
textbox on the report header. The error is thrown at the filter
created for the report when I docmd openreport. The error is not
thrown if the =count(*) is not used. I want the textbox in the header
of the report to show the number of records in the report.

seeker53

Make sure the text box is in the Report Header section, not the Page Header
section.

Try adding quotes, e.g.:
=Count("*")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"seeker52" <akinfam@hotmail.com> wrote in message
news:8c9f7d3a.0404151810.6159ba9e@posting.google.c om...[color=blue]
> I receive an error 3464 when I put =count(*) in the controlsource of a
> textbox on the report header. The error is thrown at the filter
> created for the report when I docmd openreport. The error is not
> thrown if the =count(*) is not used. I want the textbox in the header
> of the report to show the number of records in the report.
>
> seeker53[/color]