K
KPR
Problem I've always faced in Access....
I want to group by LastName and then show the [Max] date, and then bring out
the ID of the record that contained the [Max] date.
LName Date ID
Smith 01/01/1900 1111
Smith 03/01/1900 2222
Smith 04/01/1900 3333
I want my query to output.....Smith | 04/01/1900 | 3333
Thanks,
Ken
I want to group by LastName and then show the [Max] date, and then bring out
the ID of the record that contained the [Max] date.
LName Date ID
Smith 01/01/1900 1111
Smith 03/01/1900 2222
Smith 04/01/1900 3333
I want my query to output.....Smith | 04/01/1900 | 3333
Thanks,
Ken