R: Query/400 problem

Martin, with SQL you may simply write:
Select Option, max(Date), count(*)  from YourFile
group by option. 
You may redirect the output to a printer.

Let me know if it's OK.
Sincerely

Domenico Finucci
Fiditalia , Milano, 02- 4301-2494


-----Messaggio originale-----
Da: Martin.Cubitt@keymed.co.uk [mailto:Martin.Cubitt@keymed.co.uk]
Inviato: mercoledì 11 ottobre 2000 12.02
A: MIDRANGE-L@midrange.com
Oggetto: 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
+---