Connecting Tech Pros Worldwide Help | Site Map

record count

seeker52
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Allen Browne
Guest
 
Posts: n/a
#2: Nov 12 '05

re: record count


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]


Closed Thread