[Download-List] Using TOTAL COUNTER

[Linda Miller]

SELECT PAYTODAT WHEN PTD.BD.CODES = 'RRSB''RESB' BY.EXP PTD.BD.CODES
LIST PAYTODAT TOTAL COUNTER  should give you the 99 count that you are 
looking for

Minatra, Pat wrote:

>I can do the following:
>-----start snip
>:GET.LIST SBAB.TOTAL
>56 records retrieved to list 0.
>  
>
>>SELECT PAYTODAT WITH PTD.BD.CODES = "RRSB"
>>    
>>
> 
>56 records selected to list 0.
> 
>  
>
>>CLS
>>    
>>
>:GET.LIST SBAB.TOTAL
>56 records retrieved to list 0.
>  
>
>>SELECT PAYTODAT WITH PTD.BD.CODES = "RESB"
>>    
>>
> 
>43 records selected to list 0.
>
>  
>
>-----end snip
>
>The two responses that I get where XX records selected to list 0 are the
>numbers that I need to add together and put into a variable that
>DOWNLOAD will recognize.
>
>I.E.
>56 records selected to list 0.
>43 records selected to list 0.
>--
>99 total contributions (even though there are 56 records)
>
>I know that I can do this in basic but this is the ONLY part of this
>that does not work like it use to back in R16 days.
>
>This is a vendor requirement and so far the ONLY solution is to manually
>input this number prior to submittal and that is just not a very good
>solution.
>
>Thanks for any help and have a GREAT day!
>
>-------------------------
>"Life is but a twinkle in the eye of eternity"
>"The shortest distance between a problem and a solution is the distance
>between your knees and the floor"
>"sorrow looks back - worry looks around - faith looks up"
>Regards,
>Pat H. Minatra - N5GJR
>(325) 670-5804 voice
>(325) 670-1570 fax
>Hardin*Simmons University  
>www.hsutx.edu
>PO BOX 16040
>Abilene, TX  79698
>
>-----Original Message-----
>From: download-list-bounces at cedarville.edu
>[mailto:download-list-bounces at cedarville.edu] On Behalf Of Minatra, Pat
>H.
>Sent: Tuesday, May 02, 2006 8:01 AM
>To: download-list at cedarville.edu
>Subject: [Download-List] Using TOTAL COUNTER
>
>I wrote a paragragh in UniData in 2001 whereby I am taking data and
>placing it into three different files and then concatenating it into one
>file as a final submittal file to be used as electronic submittal.
>
>The TOTAL COUNTER process use to count the contributions and now ONLY
>counts records.
>
>Example:
>
>A record can have an employer contribution (always) and MAYBE an
>employee contribution.
>
>I was using the TOTAL COUNTER to total how total contributions (not
>records) were actually made; 25 records, employer contributes 25 times,
>employees contribute only 12, toal would be 37 but TOTAL COUNTER now
>reports 25 and use to report 37.  I have not changed the code but the
>counting 'result' changed in 2003 (which is the SAME time we came up on
>R17 but that should not have made a difference).
>
>So, my question is...is there some keyword I can use to be able to get
>this number and report the number out to the third file which uses this
>'total' number of contributions and not line items.
>
>Thank you so much for any and all help.  Have a GREAT day!
>
>-------------------------
>"Life is but a twinkle in the eye of eternity"
>"The shortest distance between a problem and a solution is the distance
>between your knees and the floor"
>"sorrow looks back - worry looks around - faith looks up"
>Regards,
>Pat H. Minatra - N5GJR
>(325) 670-5804 voice
>(325) 670-1570 fax
>Hardin*Simmons University  
>www.hsutx.edu
>PO BOX 16040
>Abilene, TX  79698
>
>_______________________________________________
>download-list mailing list
>download-list at cedarville.edu
>http://mail.cedarville.edu/mailman/listinfo/download-list
>
>_______________________________________________
>download-list mailing list
>download-list at cedarville.edu
>http://mail.cedarville.edu/mailman/listinfo/download-list
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20060503/05a5f59f/attachment.html>