summary sheets from temp file

[Chris Rendall]

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.  

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.

--- Chris

-----Original Message-----
From: scooter6 at gmail.com [mailto:scooter6 at gmail.com] 
Sent: Monday, July 14, 2014 3:46 PM
To: Kenneth Brody
Cc: filepro-list at lists.celestial.com
Subject: Re: summary sheets from temp file

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
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list