<div dir="ltr"><div>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) ?</div>
<div>The first 3 pages (for clients 2435, 3194 and 3981) show aa is blank but ab is correct -- </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 4:42 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <span dir="ltr"><<a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Field 1 is client number (i.e. 2435, 3194, 3981, 5499)</div><div>Field 2 is acct number</div><div>
Field 3 is those 2 fields combined with a "-" in middle (i.e. 2435-0126, 3194-0143)</div><div>
</div><div>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?</div>
<div>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....?</div>
<div> </div><div> </div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 4:29 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote"><div>On 7/14/2014 4:21 PM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
Seems to me it's going thru @sbrk1 after each record.....I put a<br>
'beep;msgbox...' statement in @sbrk as shown and it increases each time I<br>
hit enter<br>
Here are the records I have in the file:<br>
<br>
2435-0126<br>
</blockquote></div>
[...]<div><br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
5499-0091<br>
<br>
So my processing now looks like this:<br>
<br>
:1="":end::<br>
@sbrk1::aa(4,#,g)=mid(3,"6","<u></u>4");beep;msgbox "Value of aa is"<aa 'this<br>
is the lowest acct number:<br>
::end:<br>
</blockquote></div>
[...]<div><br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
My sort information is:<br>
<br>
Sort field : 1 | 2<br>
Length : 4 | 4<br>
Descending: |<br>
Subtotal field: x |<br>
</blockquote></div>
[...]<br>
<br>
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?<span><font color="#888888"><br>
<br>
-- <br>
Kenneth Brody<br>
</font></span></blockquote></div><br></div>
</div></div></blockquote></div><br></div>