dbTalk Databases Forums  

record count

comp.database.ms-access comp.database.ms-access


Discuss record count in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
seeker52
 
Posts: n/a

Default record count - 04-15-2004 , 11:51 AM






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

Reply With Quote
  #2  
Old   
Ray
 
Posts: n/a

Default Re: record count - 04-16-2004 , 07:53 AM






akinfam (AT) hotmail (DOT) com (seeker52) wrote in message news:<8c9f7d3a.0404150851.4daa2e09 (AT) posting (DOT) google.com>...
Quote:
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
Hello Seeker,

Try using the following:

=Count([RecordID])

I've never used the * symbol in a function before,
only due to the fact that I've never thought about
it before.

Anyway, I have always used the RecordID, or another
field, in the function. Perhaps by using the * symbol,
Access has trouble with it.

Regards,

Ray


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.