Access And Sql

[ketedford]

Please help me out with this query. I am new and desparate for help:

I have a table such as this one:

ACCT DATE RANK
119 5/8/2005 4
145 5/11/2005 4
145 8/10/2005 6
145 4/18/2005 4
146 9/17/2005 6
146 7/16/2005 7
146 8/2/2005 6
147 9/12/2005 4
147 9/11/2005 4
147 4/6/2005 3
147 7/6/2005 4
150 12/29/2004 4
153 4/10/2005 2
153 3/28/2005 4
153 2/13/2005 2

I need to group by ACCT and showing just the lowest RANK along with the date that is associated with that RANK (Using the earliet date, if possible). Please, how can I do that?


Thank you in advance for any assistance.

[Metale]

first of all the field DATA must be Date/Time type
make a select query with ACCT and DATA fields
choose Totals from View and select GroupBy for ACCT and Min for Data.
Run the query
The result must be a value for ACCT and the earliest data for DATA field.
good luck

[ketedford]

I'll give it a try Monday and let you know. Thanks for the help.