Display the first and last record
Hi, we have a table like below (sorted by Name, Date)
Name Date
AA 11-Jan-2001
AA 21-Sep-2001
AA 10-Dec-2001
AA 01-Mar-2002
BB 21-Jan-2001 BB 30-Sep-2001 BB 19-Nov-2001 BB 01-Apr-2002 We would like to have the report to show the first date and last date by name like Name First Date Last Date AA 11-Jan-2001 01-Mar-2002 BB 21-Jan-2001 01-Apr-2002 How can we do this report? Thanks.
Veronica
0