Simple Count

[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

 

[Fredg]

Shawn,
To display just the total count ...
In an unbound control's Control Source:
=Count()

 

[Fredg]

Where in the report did you place the control?
What is the name of the control?
Exactly what are you getting?
Or not getting?

 

[Shawn]

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.





.

 

[_Bigred]

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

 

[Fredg]

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.

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

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