Gustav Brock
Gustav at cactus.dk
Fri Apr 20 05:49:27 CDT 2007
Hi Paul Look here for a method that you should be able to tweak: http://databaseadvisors.com/mailman/htdig/accessd/2006-May/043938.html /gustav >>> paul.hartland at fsmail.net 20-04-2007 12:25 >>> To all, Not quite sure how to put this but I have the following example result set from a query: LaptopNamesOwnerUserNameMaxOfLastUsed ADDER RAYATKINSON JOHNCLEGG 15/02/2007 10:30:14 ADDER RAYATKINSON ANDREWNORRIDGE 02/02/2007 12:01:29 ADDER RAYATKINSON IANNEWCOMBE 05/12/2006 12:50:01 ADDER RAYATKINSON JIMMYWILSON 30/09/2006 12:01:47 ADDER RAYATKINSON RICHARDMASKERY 30/08/2006 12:53:11 ADDER RAYATKINSON BRIANTHOMAS 23/07/2006 14:33:47 ADDER RAYATKINSON BRIANTHOMAS 12/05/2006 12:57:59 ALBANIA TERRYJONES JOHNCLEGG 20/09/2006 12:41:40 ALBANIA TERRYJONES LYLEBARRAS 20/09/2006 10:43:37 ALBANIATERRYJONESKAITSANG21/08/2006 11:33:10 What I need to end up with is this: ADDER RAYATKINSON JOHNCLEGG 15/02/2007 10:30:14 ALBANIA TERRYJONES JOHNCLEGG 20/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 at fsmail.net 07730 523179