It's been a while, but I think that you can leverage the min and max functions for this. <div id="yMail_cursorElementTracker_1594807059084"><br></div><div id="yMail_cursorElementTracker_1594807059675">In your processing at line 1 (before the @brk) do something like ;</div><div id="yMail_cursorElementTracker_1594807142085">Aa=min(acctfield) ; ab=max(acctfield) </div><div id="yMail_cursorElementTracker_1594807257821"><br></div><div id="yMail_cursorElementTracker_1594807258113">Now you can reference aa and ab when you are at the break and will have the expected values. <br><div id="yMail_cursorElementTracker_1594807038759"><br><div id="ymail_android_signature"><a id="ymail_android_signature_link" href="https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature">Sent from Yahoo Mail on Android</a></div> <br> <blockquote style="margin: 0 0 20px 0;"> <div style="font-family:Roboto, sans-serif; color:#6D00F6;"> <div>On Wed, Jul 15, 2020 at 1:59 AM, scooter6--- via Filepro-list</div><div><filepro-list@lists.celestial.com> wrote:</div> </div> <div style="padding: 10px 0 0 20px; margin: 10px 0 0 0; border-left: 1px solid #6D00F6;"> I guess that's the part I'm struggling with - since I'm using index for<br clear="none">date, the first record it finds may not be the lowest number in that 'batch'<br clear="none">Would it be better to create an index on date and full account number, then<br clear="none">grab the first 'acct'?<br clear="none">thanks<br clear="none"><br clear="none"><br clear="none">On Mon, Jul 13, 2020 at 3:59 PM Bruce Easton via Filepro-list <<br clear="none"><a shape="rect" ymailto="mailto:filepro-list@lists.celestial.com" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote:<br clear="none"><br clear="none">> Scott - if the only problem is the Starting Acct#, then, are you using a<br clear="none">> global field to track when the Starting Acct# is less than one<br clear="none">> previously encountered within a Ctl#?   (And then resetting it back to<br clear="none">> an arbitrarily high value when you start a new Ctl# after reporting the<br clear="none">> Ctl#?)<br clear="none">><br clear="none">> Bruce<br clear="none">><br clear="none">><br clear="none">> On 7/13/20 2:12 PM, scooter6--- via Filepro-list wrote:<br clear="none">> > I have a database that has this type structure<br clear="none">> ><br clear="none">> > Clt             Acct          Full Acct                  Date Received<br clear="none">> > -------         ---------      ----------------------<br clear="none">> >   -----------------------<br clear="none">> > 01234        00010      01234-00010          06/01/20<br clear="none">> > 01234        00011      01234-00011           06/01/20<br clear="none">> > 01234        00012      01234-00012           06/05/20<br clear="none">> > 01234        00013      01234-00013           06/10/20<br clear="none">> > 01235        00250      01235-00250           06/01/20<br clear="none">> > 01235        00251      01235-00251           06/05/20<br clear="none">> ><br clear="none">> > I want to create a report with oldest received date first and a 'summary'<br clear="none">> > line for each batch then in Clt number order<br clear="none">> ><br clear="none">> > For example, for the above data set, I want to see<br clear="none">> ><br clear="none">> > Date Rec'd      Clt             Starting Acct      Ending Acct<br clear="none">> Total<br clear="none">> > in Batch<br clear="none">> > ---------------      -----------    -----------------<br clear="none">> > ----------------         ------------------<br clear="none">> > 06/01/20           01234        00010               00011<br clear="none">> >           2<br clear="none">> > 06/01/20           01235        00250               00250<br clear="none">> >           1<br clear="none">> >                            Total Received 06/01/20<br clear="none">> >                3<br clear="none">> ><br clear="none">> > 06/05/20           01234        00012               00012<br clear="none">> >           1<br clear="none">> > 06/05/20           01235        00251               00251<br clear="none">> >           1<br clear="none">> >                             Total Received 06/05/20<br clear="none">> >               2<br clear="none">> ><br clear="none">> > 06/10/20           01234        00013               00013<br clear="none">> >           1<br clear="none">> >                              Total Received 06/10/20<br clear="none">> >                1<br clear="none">> ><br clear="none">> ><br clear="none">> > When I do @wbrk1 - I can get the Ending Account and the Total but even<br clear="none">> if I<br clear="none">> > declare the Starting Acct before @wbrk1 - both variables still come out<br clear="none">> the<br clear="none">> > same - so I'm apparently missing something there<br clear="none">> ><br clear="none">> > I'm using sort order of Date Rec'd and descending and subtotal and<br clear="none">> subtotal<br clear="none">> > on Clt<br clear="none">> > Running this rreport with -ih  (index H which is Date Rec'd)<br clear="none">> ><br clear="none">> > I can post full processing table if that helps - but each report dataline<br clear="none">> > is a field in the actual file<br clear="none">> > There is a little more I'm doing with it other than this, but it's really<br clear="none">> > just displaying a few of the other fields - so didn't want to confuse by<br clear="none">> > posting the full prc table<br clear="none">> ><br clear="none">> > thanks<br clear="none">> > Scott<br clear="none">> > PDM<br clear="none">> > -------------- next part --------------<br clear="none">> > An HTML attachment was scrubbed...<br clear="none">> > URL: <<br clear="none">> <a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html</a><br clear="none">> ><br clear="none">> > _______________________________________________<br clear="none">> > Filepro-list mailing list<br clear="none">> > <a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">> > Subscribe/Unsubscribe/Subscription Changes<br clear="none">> > <a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none">><br clear="none">><br clear="none">> _______________________________________________<br clear="none">> Filepro-list mailing list<br clear="none">> <a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">> Subscribe/Unsubscribe/Subscription Changes<br clear="none">> <a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none">><br clear="none">-------------- next part --------------<br clear="none">An HTML attachment was scrubbed...<br clear="none">URL: <<a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200714/670932b6/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20200714/670932b6/attachment.html</a>><div class="yqt2786093178 yQTDBase" id="yqtfd13121"><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"></div> </div> </blockquote></div></div>