summary sheets from temp file

[scooter6 at gmail.com]

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
Now if I can just figure out why aa is always blank then I'll be
set.....thanks for that tip....
Scott


On Mon, Jul 14, 2014 at 4:54 PM, Chris Rendall <crendall at teamind.com> wrote:

> 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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/d1bbbae1/attachment.html