Extracting Data using MAX

[gazza11]

I have an Access 2000 table with an ID, dates and other info. Eg:
ID Date
1 1/1/99
2 2/1/99
3 3/1/99
1 10/6/00
2 11/6/00
2 12/6/00

I need to extract the latest date for each ID but I also need that ID as I use the dataset created in Crystal reports.
My dataset should contain
1 10/6/00
2 12/6/00
3 3/1/99

I used the MAX function to get the latest date but cannot get the ID (Aggregate function error). Can someone please assist me.

 

[jrbarnett]

Hi,

Use the following SQL query:

Select ID, Max (Date)
From Table
Group By ID
Order By ID

John

 

[gazza11]

Many thanks
Gary