[AccessD] Getting Top Values Again - Sorry about last email

paul.hartland at fsmail.net paul.hartland at fsmail.net
Fri Apr 20 05:25:36 CDT 2007


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


More information about the AccessD mailing list