G
Guest
I have a table with a 2-field primary key, Custid (sort: Ascending) and Date
(Sort: Descending). The combination of the two fields creates a unique key.
I want to write a query that will return, for each customer, the most recent
record entered for him/her. Example:
custid date
1 10/20/2004
1 8/7/2003
1 7/13/2002
2 1/13/2001
2 3/3/1999
2 1/1/1998
Returned recordset would contain
1 10/20/2004
2 1/13/2001
Appreciate the help. I am using MS Access 2000 in Win XP
(Sort: Descending). The combination of the two fields creates a unique key.
I want to write a query that will return, for each customer, the most recent
record entered for him/her. Example:
custid date
1 10/20/2004
1 8/7/2003
1 7/13/2002
2 1/13/2001
2 3/3/1999
2 1/1/1998
Returned recordset would contain
1 10/20/2004
2 1/13/2001
Appreciate the help. I am using MS Access 2000 in Win XP