summary sheets from temp file

[scooter6 at gmail.com]

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/3b81387c/attachment.html