[AccessD] group min - max

Why obsess over using a single query? Use two like Jack originally suggested. For one this Access/JET really sucks with sub-queries run against large record sets like you have.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
Sent: Tuesday, December 07, 2010 9:38 AM
To: pedro at plex.nl
Cc: AccessD at databaseadvisors.com
Subject: Re: [AccessD] group min - max

Hello Jack,

i used your query, but it gives the max-min value of the additional-field (last Column), and with many the same dates and additional-field values, i have more then one record.
It is more important to me to have the max or min date, with the additional-field value.

Let me explain more
for example.
<snip>