[AccessD] Getting the recordcount for a report

Heenan, Lambert Lambert.Heenan at AIG.com
Fri Jun 20 15:14:16 CDT 2003


Just put a textbox in the header (or footer) with the data source set to...

=Count(*)

That should do it.

Lambert

> -----Original Message-----
> From:	Don Elliker [SMTP:delliker at hotmail.com]
> Sent:	Friday, June 20, 2003 2:48 PM
> To:	accessd at databaseadvisors.com
> Subject:	[AccessD] Getting the recordcount for a report 
> 
> Folks,
> 
> Does anyone know of a good way to get the recordcount for a report? I have
> a need to capture that and display it in the header. Aside from taking the
> report recordsource and creating a recordset and getting the recordcount
> from movelast method I can't find anything useful. The aforementioned
> seems a little overhead intensive.
> _d
> 
> "Things are only free to the extent that you don't pay for them".-Don
> Elliker 
> 
> 
>   _____  
> 
> STOP MORE SPAM with the new MSN 8 <http://g.msn.com/8HMGENUS/2728??PS=>
> and get 2 months FREE* << File: ATT5737557.txt >> 


More information about the AccessD mailing list