Only way I can think of is a two pass method.

1.) Using query read through your file sorted in CUST# order.  Summarize
Min and Max on the date field.  Break on CUST#.   Output to a database file
summary only.  This should create a file with CUST#, MIN CCYYMMDD, MAX
CCYYMMDD.

2.) Use query to join your original file with the new file and you should
be able to calculate your days doing business....

Let me know if I'm on target...

BTW, I briefly worked at one of your sister companies RGA (now defunct of
course).....




Hi All,
Question:  I have a simple transaction file (physical file) I have to
process for a report, this file is sequenced by CUST# then CCYYMMDD.
Now for the summary query reporting on the CUST#, I want get the (MIN)
and the (MAX) in the CCYYMMDD field (column) so I can do the math in the
query using the 2 fields (MIN) and (MAX) in order to arrive at the
number of days we've done business with this Customer.  Suggestions
appreciated on how I convert the (MIN) and the (MAX) to useable field
names within the query.
TIA
----
Tim Truax
RPS, Inc
1000 RPS Drive
Moon Township,  PA  15108












+---
| 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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].