<div dir="ltr"><div>Yes that's what it said - so I did as you said and yes, in fact the beep msgbox only is encountered once - thanks now line 1 is blank in the If: and Then: end</div><div>Now if I can just figure out why aa is always blank then I'll be set.....thanks for that tip....</div>
<div>Scott</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 4:54 PM, Chris Rendall <span dir="ltr"><<a href="mailto:crendall@teamind.com" target="_blank">crendall@teamind.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Does the first "If" line in your code have the "If 1="" then end"? If so, take out the 1="" from the "If" line and just leave the "end" on the then line.<br>
<br>
If field 1 is not equal to blank then the code will continue into the @sbrk1 code, and then the code in @sbrk1 runs again when the break value changes causing it to run twice like you are seeing.<br>
<br>
--- Chris<br>
<div><br>
-----Original Message-----<br>
From: <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> [mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>]<br>
Sent: Monday, July 14, 2014 3:46 PM<br>
To: Kenneth Brody<br>
Cc: <a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a><br>
Subject: Re: summary sheets from temp file<br>
<br>
</div><div><div class="h5">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<br>
number) does show aa as 0091 and ab as 0091 (which 0091 is the highest acct number for 5499) ?<br>
The first 3 pages (for clients 2435, 3194 and 3981) show aa is blank but ab is correct --<br>
<br>
<br>
On Mon, Jul 14, 2014 at 4:42 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>><br>
wrote:<br>
<br>
> Field 1 is client number (i.e. 2435, 3194, 3981, 5499) Field 2 is<br>
> acct number Field 3 is those 2 fields combined with a "-" in middle<br>
> (i.e. 2435-0126,<br>
> 3194-0143)<br>
><br>
> If I change message box to show all 3, it says "Value of field 1 is<br>
> 2435 field 2 is 0126 field 3 is 2435-0126" When it encounters the<br>
> very first record of each unique client number, I have to hit enter<br>
> twice - and these values do not change after hitting enter first<br>
> time....only after hitting enter for 2nd time does it go to the next<br>
> account - but it's only the first acct it finds under each client? Why would that be?<br>
> For instance, when I get to client 5499, the message box shows "Value<br>
> of field 1 is 5499 field 2 is 0086 field 3 is 5499-0086" After I hit<br>
> enter first time, the values stay the same....BUT, after I hit enter<br>
> for the 2nd time, and every consecutive time, it increments the values<br>
> properly....so after I hit enter for 2nd time, it shows 5499-0087,<br>
> then after 3rd time, it shows 5499-0088 and so on, but on the first<br>
> record it finds for each unique client number, I have to hit enter twice....?<br>
><br>
><br>
><br>
><br>
> On Mon, Jul 14, 2014 at 4:29 PM, Kenneth Brody <<a href="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a>><br>
> wrote:<br>
><br>
>> On 7/14/2014 4:21 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
>><br>
>>> 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<br>
>>> time I hit enter Here are the records I have in the file:<br>
>>><br>
>>> 2435-0126<br>
>>><br>
>> [...]<br>
>><br>
>> 5499-0091<br>
>>><br>
>>> So my processing now looks like this:<br>
>>><br>
>>> :1="":end::<br>
>>> @sbrk1::aa(4,#,g)=mid(3,"6","4");beep;msgbox "Value of aa is"<aa<br>
>>> 'this is the lowest acct number:<br>
>>> ::end:<br>
>>><br>
>> [...]<br>
>><br>
>> My sort information is:<br>
>>><br>
>>> Sort field : 1 | 2<br>
>>> Length : 4 | 4<br>
>>> Descending: |<br>
>>> Subtotal field: x |<br>
>>><br>
>> [...]<br>
>><br>
>> Since you're sorting on field 1, perhaps you should show us the value<br>
>> of that field? Maybe the message box should show the values of<br>
>> fields 1, 2, and 3?<br>
>><br>
>> --<br>
>> Kenneth Brody<br>
>><br>
><br>
><br>
</div></div><div>-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
</div>URL: <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/e5112040/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/e5112040/attachment.html</a><br>
<div class="HOEnZb"><div class="h5">_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>