summary sheets from temp file

[scooter6 at gmail.com]

A little stumped here
I have a temp file we put records in during day....and I'd like to print a
summary 'cover sheet' nightly based on what is in this file

So I have records that will look like this (all based on client number,
which is first 4 numbers of our 'Account Number')

2435-0001        John Smith
2435-0002        Jane Doe
3194-0143        John Consumer
3194-0144         Billy Carter
3194-0145         Ronald Reagan
5498-0254         George Bush
5498-0255         Bill Clinton

So, at night, I want to print 3 'CoverSheets' (one for each unique client
number: 2435, 3194 & 5498)

The CoverSheet report will basically say:

Client Number:    2435
Client Name    :   *aa  (this will lookup the client file using 2435 and
grab the client name)
# of Records    :   2     (this should count 2435-0001 & 2435-0002 and
total unique records)
Starting acct     :  0001  (lowest 'acct' for 2435)
Ending acct      :  0002   (highest 'acct' for 2435)

Client Number:   3194
Client Name : *aa (this will lookup the client file using 2435 and grab the
client name)
# of Records :   3     (this should count 2435-0001 & 2435-0002 and total
unique records)
Starting acct : 0143  (lowest 'acct' for 2435)
Ending acct : 0145   (highest 'acct' for 2435)

etc


Can't seem to figure out how to get this to work -- do I need to do an
@wbrk and just select all records at night or do I need add'l output
processing to segregate this data 'by client'?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140702/3688e73d/attachment.html