<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="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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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 class="HOEnZb"><font color="#888888"><br>
<br>
-- <br>
Kenneth Brody<br>
</font></span></blockquote></div><br></div>