RE: Query/400 problem

Sort by option and take max(Date)

> -----Original Message-----
> From: Martin.Cubitt@keymed.co.uk [SMTP:Martin.Cubitt@keymed.co.uk]
> Sent: Wednesday, October 11, 2000 6:02 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Query/400 problem
> 
> We have a simple file holding three fields:
> 
> Option (10A), User (10A), Date (10L)
> 
> Eg:
> 
> Option User Date
> A           Joe  2000-10-01
> A           Pete 2000-09-30
> A           Joe  2000-09-20
> B           Brian     2000-09-29
> C           Judy 2000-09-30
> C           Liz  2000-01-07
> C           Joe  1999-12-22
> 
> I want to write a query that will show me the last time an option was
> used,
> no matter who by, resulting in:
> 
> A           2000-10-01
> B           2000-09-29
> C           2000-09-30
> 
> 
> Any ideas?  Thank you!
> 
> Martin
> 
> 
> 
> 
> 
> 
> This message has been virus checked with appropriate software used by
> KeyMed (Medical & Industrial Equipment) Ltd., but neither it nor any
> attachments can be guaranteed free from viruses or other defects and the
> recipient accepts sole responsibility for any consequences arising from
> opening this message or any attachments.  The comments contained in this
> message are personal to the sender, who accepts sole responsibility for
> them.  They should not be taken to represent the company's views or
> position, which may differ in whole or in part from those expressed by the
> sender.
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---