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 >>