Jack and Pat
drawbridgej at sympatico.ca
Thu Jan 8 15:46:47 CST 2009
Susan, Not sure if this is what you mean, but I did find this. Hope it's useful. http://accessblog.net/2007/03/how-to-limit-number-of-records-showed.html Jack -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Thursday, January 08, 2009 4:08 PM To: AccessD at databaseadvisors.com Subject: [AccessD] limit the number of records in a group I know we've had a number of discussions about how to limit the number of records for a group and I even wrote about it -- a simple technique for doing this in a report. I seem to remember that it can also be done with a subquery -- I've checked the archives, but I'm not coming up with anything. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.10.5/1881 - Release Date: 1/7/2009 5:59 PM