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