paul.hartland at fsmail.net
paul.hartland at fsmail.net
Fri Apr 20 05:14:30 CDT 2007
To all, Not quite sure how to put this but I have the following example result set from a query: LaptopNamesOwnerUserNameMaxOfLastUsed ADDERRAYATKINSONJOHNCLEGG15/02/2007 10:30:14 ADDERRAYATKINSONANDREWNORRIDGE02/02/2007 12:01:29 ADDERRAYATKINSONIANNEWCOMBE05/12/2006 12:50:01 ADDERRAYATKINSONJIMMYWILSON30/09/2006 12:01:47 ADDERRAYATKINSONRICHARDMASKERY30/08/2006 12:53:11 ADDERRAYATKINSONBRIANTHOMAS23/07/2006 14:33:47 ADDERRAYATKINSONBRIANTHOMAS.12/05/2006 12:57:59 ALBANIATERRYJONESJOHNCLEGG20/09/2006 12:41:40 ALBANIATERRYJONESLYLEBARRAS20/09/2006 10:43:37 ALBANIATERRYJONESKAITSANG21/08/2006 11:33:10 What I need to end up with is this: Query1LaptopNamesOwnerUserNameMaxOfLastUsed ADDERRAYATKINSONJOHNCLEGG15/02/2007 10:30:14 ALBANIATERRYJONESJOHNCLEGG20/09/2006 12:41:40 i.e the maximum date....I am sure there has been a solution to this on here before, but I can seem to find it.. Thanks in advance for any help on this.. Paul Hartland Paul Hartland paul.hartland at fsmail.net 07730 523179