counting records (1 Viewer)

bauer

Registered User.
Local time
Today, 06:09
Joined
Aug 23, 2001
Messages
77
I know that this has been dealt with before, however, I am having trouble with this one. I want to count all of the records that pop up on the report. I have used =count([primarykey]) in a text box, but what I get is a count muktiplied by some number (which is not always the same otherwise I would just divide it). If someone can help me, that would be great, thank you.

bauer@aol.com
 

Hunter

Registered User.
Local time
Today, 11:09
Joined
Feb 2, 2000
Messages
24
Try this text in a text box in the Report Footer section:

="Total Number of Initiatives is: " & Count(*)
 

ptaylor-west

Registered User.
Local time
Today, 11:09
Joined
Aug 4, 2000
Messages
193
If you only want to count the pop up's use

= Count (Column Name) instead of Count(*) the first counts rows that are not empty the latter counts all the rows.

HTH

Paul
 

Users who are viewing this thread

Top Bottom