Simple Count

  • Thread starter Thread starter Shawn
  • Start date Start date
S

Shawn

Hi,
I just need a count on my report that shows how many
records are on the report. Could someone please help me.
Thank you,
Shawn
 
Shawn,
To display just the total count ...
In an unbound control's Control Source:
=Count()
 
Where in the report did you place the control?
What is the name of the control?
Exactly what are you getting?
Or not getting?
 
Fred
Thanks. That's exactly what I needed.
Shawn
-----Original Message-----
Oops...
You're right, it should have been
=Count(*)

Place it in the Report Footer (not the Page Footer) and it will give the
total number of records in the report.
If you place it in a Group Footer (or Header) it will return just the number
of records in that group.
If you place it in the Page Footer you will get #Error.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.





.
Click to expand...
 
I personally use the following style of code:


I create a unbound text box, then set the control source:
=DCount("[ID]","[My Table]")

Later,
_Bigred
 
DCount counts the number of records in the table,
not the number of records actually in the report.

Filter a report that returns 25 records from a table
holding 100, and your solution will read 100, while
the actual count of records in the report should be 25,
which is what the poster wanted.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


_Bigred said:
I personally use the following style of code:


I create a unbound text box, then set the control source:
=DCount("[ID]","[My Table]")

Later,
_Bigred



Shawn said:
Hi,
I just need a count on my report that shows how many
records are on the report. Could someone please help me.
Thank you,
Shawn
Click to expand...
Click to expand...
 
Back
Top