[AccessD] limit the number of records in a group

Susan,

I checked Accessd records and found this(quoted below). I have no idea of
the context, but it may trigger something with you, or it may point to a
Date where a conversation occurred.

" From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, August 23, 2007 2:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Limit number of records

Whatever works. :) 

Susan H. 

Hi Susan,

This feels like kind of cheating...........I went into the main queries,
limited the number of records to the top 5, then saved each query, created
an mde and deployed the application using the developer extensions.

Worked great.  Now the application will only show 5 records.

?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, January 08, 2009 5:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] limit the number of records in a group

Gustav and Jack -- thanks for the links -- I'm flagging them both. However, 
I thought someone had come up with a subquery solution. I guess I'm 
remembering something else and just have the bits and pieces confused. I 
tried several subqueries this afternoon, but nothing that worked or even got

me to the point where I thought I was on the right track.

Susan H.


> Hi Susan
>
> Could it be this, for a form though:
>
> http://databaseadvisors.com/pipermail/accessd/2004-January/018848.html
>

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