[AccessD] Getting the recordcount for a report

Heenan, Lambert Lambert.Heenan at AIG.com
Fri Jun 20 16:10:48 CDT 2003


=Count(*) works just as well in the group header/footer. So you CAN see the
count per grouping.

> -----Original Message-----
> From:	Don Elliker [SMTP:delliker at hotmail.com]
> Sent:	Friday, June 20, 2003 4:39 PM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] Getting the recordcount for a report
> 
> 
> Like it! It does work  - now if it would only tell me how many records
> were 
> accessed below the groupby. It gives back the count of records but it
> seems 
> I need the count that went into the grouping.
> Thanks! (it's still a neat trick)
> _D
> "Things are only free to the extent that you don't pay for them".-Don 
> Elliker
> 
> 
> 
> 
> 
> >From: "Heenan, Lambert" <Lambert.Heenan at AIG.com>
> >Reply-To: accessd at databaseadvisors.com
> >To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
> >Subject: RE: [AccessD] Getting the recordcount for a report Date: Fri, 20
> 
> >Jun 2003 16:14:16 -0400
> >
> >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 >>
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> 
> _________________________________________________________________
> Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list