summary sheets from temp file

[scooter6 at gmail.com]

One more thing to note, on the actual print outs with this processing, the
last page it prints (for client 5499, which is in fact the highest client
number) does show aa as 0091 and ab as 0091 (which 0091 is the highest acct
number for 5499) ?
The first 3 pages (for clients 2435, 3194 and 3981) show aa is blank but ab
is correct --


On Mon, Jul 14, 2014 at 4:42 PM, scooter6 at gmail.com <scooter6 at gmail.com>
wrote:

> Field 1 is client number  (i.e. 2435, 3194, 3981, 5499)
> Field 2 is acct number
> Field 3 is those 2 fields combined  with a "-" in middle  (i.e. 2435-0126,
> 3194-0143)
>
> If I change message box to show all 3, it says "Value of field 1 is 2435
> field 2 is 0126 field 3 is 2435-0126"  When it encounters the very first
> record of each unique client number, I have to hit enter twice - and these
> values do not change after hitting enter first time....only after hitting
> enter for 2nd time does it go to the next account - but it's only the first
> acct it finds under each client? Why would that be?
> For instance, when I get to client 5499, the message box shows "Value of
> field 1 is 5499 field 2 is 0086 field 3 is 5499-0086"  After I hit enter
> first time, the values stay the same....BUT, after I hit enter for the 2nd
> time, and every consecutive time, it increments the values properly....so
> after I hit enter for 2nd time, it shows 5499-0087, then after 3rd time, it
> shows 5499-0088 and so on, but on the first record it finds for each unique
> client number, I have to hit enter twice....?
>
>
>
>
> On Mon, Jul 14, 2014 at 4:29 PM, Kenneth Brody <kenbrody at spamcop.net>
> wrote:
>
>> On 7/14/2014 4:21 PM, scooter6 at gmail.com wrote:
>>
>>> Seems to me it's going thru @sbrk1 after each record.....I put a
>>> 'beep;msgbox...' statement in @sbrk as shown and it increases each time I
>>> hit enter
>>> Here are the records I have in the file:
>>>
>>> 2435-0126
>>>
>> [...]
>>
>>  5499-0091
>>>
>>> So my processing now looks like this:
>>>
>>> :1="":end::
>>> @sbrk1::aa(4,#,g)=mid(3,"6","4");beep;msgbox "Value of aa is"<aa
>>>  'this
>>> is the lowest acct number:
>>> ::end:
>>>
>> [...]
>>
>>  My sort information is:
>>>
>>>    Sort field     :   1    |  2
>>>    Length        :   4    |  4
>>>    Descending:         |
>>> Subtotal field:    x   |
>>>
>> [...]
>>
>> Since you're sorting on field 1, perhaps you should show us the value of
>> that field?  Maybe the message box should show the values of fields 1, 2,
>> and 3?
>>
>> --
>> Kenneth Brody
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/e5112040/attachment.html