Don

Either Quiz or Qtp can accomplish the same results. Your choice.

Sort the records on whatever makes up the key for the final record. If the
record layouts for regular and overtime hours are identical then you only
need to subtotal the hours and write out the subtotal AT the sort break. If
the record layouts are different then you'll need some sort of define to get
the hours values, which you would then subtotal.

Send me some more details and I'll write the code for you :-)

Regards,
JWP

> -----Original Message-----
> From: Harrington, Don [SMTP:[log in to unmask]]
> Sent: Thursday, November 08, 2001 1:43 PM
> To:   [log in to unmask]
> Subject:      QTP Question
>
> Gang;
>
> I receive a file from an IBM system that contains regular and overtime
> hours
> in two separate records.  I would like to combine them and the total hours
> into one record by job number or some other element.  How can that be done
> (can it be done?)?  I was thinking of some sort of min/max thing creating
> the subfile with an AT clause.  Would QUIZ be a better tool for this?
>
> TIA,
> Don Harrington
> Sr. Systems Analyst
> Facilities Applications Support
> Shared Services Group
> The Boeing Company
> P.O. Box 3707 M/C 6C-AK
> Seattle, WA  98124-2207
> (v) 425-234-1145 (f) 425-234-0464 (p) 206-797-6360
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *