<div dir="ltr">la (lowest) and lb (highest) come out the exact same?<div>but this puts me on the right track - I 'think' I can work on it from here - I appreciate you taking time to assist</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 16, 2020 at 3:04 PM Richard D. Williams <<a href="mailto:richard@appgrp.net">richard@appgrp.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
Sorry again, I meant field 2.<br>
<br>
Yes you are right.<br>
<br>
Richard<br>
<br>
<br>
<div>On 7/16/2020 1:46 PM,
<a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">Only part that confused me was here
<div><br>
</div>
<div> 9 ------- - - - - - - - - - - -
- - -<br>
If: cn ne 1<br>
Then: cn(5,#,g)=1;la(5,#,g)="";lb(5,#,g)=""<br>
10 ------- - - - - - - - - - - -
- - -<br>
If: la lt 2<br>
Then: la=4<br>
11 ------- - - - - - - - - - - -
- - -<br>
If: 2 gt lb<br>
Then: lb=4<br>
</div>
<div><br>
</div>
<div>4 being the 'date' field, you're saying if la (lowest
acct) lt 2 (acct#) then you're making la = 4 which is the
date field?</div>
<div>Should that be la=2 ?</div>
<div>Same on following line - if 2 gt lb then lb=4 ? </div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Jul 16, 2020 at 9:32
AM Richard D. Williams via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi
Scott,<br>
<br>
This "should" do it. (see below)<br>
<br>
Richard D. Williams<br>
(713) 931-9938<br>
<br>
1 ------- - - - - - - - - - - - -
- - - -<br>
If: 'fields - 1 clt#, 2 acct#, 3 full acct#, 4 date<br>
Then:<br>
2 ------- - - - - - - - - - - -
- - - - -<br>
If: 'set sub-total by date and then clt#<br>
Then:<br>
3 ------- - - - - - - - - - - -
- - - - -<br>
If: 'in the date sub-total area use @RS to count how
many<br>
Then: 'record were reported on that date<br>
4 ------- - - - - - - - - - - -
- - - - -<br>
If: 'in the clt# sub-total area put the variables
for<br>
Then: 'the lowest acct# - la and the highest acct# lb<br>
5 ------- - - - - - - - - - - -
- - - - -<br>
If: '<br>
Then: '<br>
6 ------- - - - - - - - - - - -
- - - - -<br>
If: 'ca keeps track when the date changes and resets
the<br>
Then: 'lowest & highest acct numbers#<br>
7 ------- - - - - - - - - - - -
- - -<br>
If: ca ne 4<br>
Then: ca(8,mdy/,g)=4;la="";lb=""<br>
8 ------- - - - - - - - - - - -
- - -<br>
If: 'cn keeps track when the clt3 changes and resets
the<br>
Then: 'lowest & highest acct numbers#<br>
9 ------- - - - - - - - - - - -
- - -<br>
If: cn ne 1<br>
Then: cn(5,#,g)=1;la(5,#,g)="";lb(5,#,g)=""<br>
10 ------- - - - - - - - - - - -
- - -<br>
If: la lt 2<br>
Then: la=4<br>
11 ------- - - - - - - - - - - -
- - -<br>
If: 2 gt lb<br>
Then: lb=4<br>
12 ------- - - - - - - - - - - -
- - -<br>
end If:<br>
Then: end<br>
<br>
On 7/13/2020 1:12 PM, scooter6--- via Filepro-list wrote:<br>
> I have a database that has this type structure<br>
><br>
> Clt Acct Full Acct
Date Received<br>
> ------- --------- ----------------------<br>
> -----------------------<br>
> 01234 00010 01234-00010 06/01/20<br>
> 01234 00011 01234-00011 06/01/20<br>
> 01234 00012 01234-00012 06/05/20<br>
> 01234 00013 01234-00013 06/10/20<br>
> 01235 00250 01235-00250 06/01/20<br>
> 01235 00251 01235-00251 06/05/20<br>
><br>
> I want to create a report with oldest received date first
and a 'summary'<br>
> line for each batch then in Clt number order<br>
><br>
> For example, for the above data set, I want to see<br>
><br>
> Date Rec'd Clt Starting Acct Ending
Acct Total<br>
> in Batch<br>
> --------------- ----------- -----------------<br>
> ---------------- ------------------<br>
> 06/01/20 01234 00010 00011<br>
> 2<br>
> 06/01/20 01235 00250 00250<br>
> 1<br>
> Total Received 06/01/20<br>
> 3<br>
><br>
> 06/05/20 01234 00012 00012<br>
> 1<br>
> 06/05/20 01235 00251 00251<br>
> 1<br>
> Total Received 06/05/20<br>
> 2<br>
><br>
> 06/10/20 01234 00013 00013<br>
> 1<br>
> Total Received 06/10/20<br>
> 1<br>
><br>
><br>
> When I do @wbrk1 - I can get the Ending Account and the
Total but even if I<br>
> declare the Starting Acct before @wbrk1 - both variables
still come out the<br>
> same - so I'm apparently missing something there<br>
><br>
> I'm using sort order of Date Rec'd and descending and
subtotal and subtotal<br>
> on Clt<br>
> Running this rreport with -ih (index H which is Date
Rec'd)<br>
><br>
> I can post full processing table if that helps - but each
report dataline<br>
> is a field in the actual file<br>
> There is a little more I'm doing with it other than this,
but it's really<br>
> just displaying a few of the other fields - so didn't
want to confuse by<br>
> posting the full prc table<br>
><br>
> thanks<br>
> Scott<br>
> PDM<br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html</a>><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200716/6d707644/attachment.html" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20200716/6d707644/attachment.html</a>><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote>
</div>
</blockquote>
<br>
<div id="gmail-m_-327808414198533810DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid rgb(211,212,222)">
<tbody><tr>
<td style="width:55px;padding-top:13px"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" style="color:rgb(68,83,234)" target="_blank">www.avg.com</a>
</td>
</tr>
</tbody></table><a href="#m_-327808414198533810_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></div>
</blockquote></div>