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

Mark A Matte markamatte at hotmail.com
Fri Apr 20 12:30:34 CDT 2007


In looking at the set of data...all of the records seem to be in the same 
format except  the last:
">ALBANIATERRYJONESKAITSANG21/08/2006 11:33:10"

There are no spaces like the other records.  If all of the records were in 
the same format...and it was impossible for the same machine to have the 
exact 2 date/times the same...you could strip out the machine name and the 
date...get max of date...and join back to the table to get the full name.

Good Luck,

Mark A. MAtte


>From: paul.hartland at fsmail.net
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd <accessd at databaseadvisors.com>
>Subject: [AccessD] Getting Top Values Again - Sorry about last email
>Date: Fri, 20 Apr 2007 12:25:36 +0200 (CEST)
>
>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
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Need a break? Find your escape route with Live Search Maps. 
http://maps.live.com/?icid=hmtag3




More information about the AccessD mailing list