Connecting Tech Pros Worldwide Help | Site Map

record count

  #1  
Old November 12th, 2005, 10:22 PM
seeker52
Guest
 
Posts: n/a
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
  #2  
Old November 12th, 2005, 10:22 PM
Allen Browne
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL*Loader - Commit point reached - logical record count 27 Hari Om answers 6 June 27th, 2008 06:09 PM
Datagrid record count Peter W Johnson answers 4 March 28th, 2006 11:25 PM
Can you get the record count inside a repeater control? darrel answers 1 November 18th, 2005 02:22 PM
PHP and MS Access Record Count thomasp@msala.net answers 3 September 11th, 2005 07:05 PM
SQL*Loader - Commit point reached - logical record count 27 Hari Om answers 6 July 19th, 2005 10:05 PM