|
Thank you so much!!!! Martin Sort by Option & Date and break on Option. In the Summary functions choose option 4 (Maximum) for the date field. Output it as Summary Only. If you need it to look nice, you can output it to a file and run another query against the summary data. 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.