last 3 in group

From: <smiths9312_at_aol.com>
Date: Thu, 10 Jun 1999 06:02:57 -0800
Message-ID: <iIP73.527$S7.254835_at_WReNphoon3>

[Quoted] Here's my problem. I need the last 3 by date items in each group. See example below:

[Quoted] A       10        1/1/99
A       20        1/21/99
A       30        2/1/99
A       45        2/23/99
B       10        1/1/99
[Quoted] B       15        1/11/99
B       20        2/11/99
B       25        2/28/99
Query would return:
A       20        1/21/99
A       30        2/1/99
A       45        2/23/99
B       15        1/11/99
B       20        2/11/99
B       25        2/28/99

I have run into a brick wall with this one. Any help you can provide would be appreciated.
Thanks!

Steve Smith

   -**** Posted from RemarQ, http://www.remarq.com/?a ****-  Search and Read Usenet Discussions in your Browser - FREE - Received on Thu Jun 10 1999 - 16:02:57 CEST