Show No of Records in Report (1 Viewer)

spacepro

Registered User.
Local time
Today, 01:45
Joined
Jan 13, 2003
Messages
715
Show No of Records in Report?

Trying to count the number of records in report based on a query.


Does anyone have the code to show the number of records in the query on the report.

Many Thanks

Andy
 

sdkramer

Registered User.
Local time
Today, 01:45
Joined
Mar 19, 2002
Messages
64
=sum([column to count]) if you're trying to count a number field
 

sdkramer

Registered User.
Local time
Today, 01:45
Joined
Mar 19, 2002
Messages
64
=count([column to count]) if you're just counting the number of records to return.
 

spacepro

Registered User.
Local time
Today, 01:45
Joined
Jan 13, 2003
Messages
715
Thank you, I knew it was something simple.

Andy
 

sdkramer

Registered User.
Local time
Today, 01:45
Joined
Mar 19, 2002
Messages
64
no problem. I hope I haven't oversimplified your question. If I misunderstood or this doesn't work let me know.

Thanks,

Seth
 

Users who are viewing this thread

Top Bottom