Don Elliker
delliker at hotmail.com
Fri Jun 20 15:39:18 CDT 2003
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