<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=281464619-03052006><FONT face="Courier New"
size=2>Yay! Thank you Linda!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=281464619-03052006><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=281464619-03052006><FONT face="Courier New"
size=2>This worked; however, I was getting mixed results; it would work part of
the time but when I would put in into my paragraph it would not work.
Then, I discovered I was using WITH instead of WHEN on selecting the proper
PTD.BD.CODES. DUH!</FONT></SPAN></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><SPAN class=281464619-03052006><FONT face="Courier New" size=2>Thank you so
much for the help, this has solved it!</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>-------------------------<BR>"Life is but a twinkle in the eye
of eternity"<BR>"The shortest distance between a problem and a solution is the
distance between your knees and the floor"<BR>"sorrow looks back - worry looks
around - faith looks up"<BR>Regards,<BR>Pat H. Minatra - N5GJR<BR>(325) 670-5804
voice<BR>(325) 670-1570 fax<BR>Hardin*Simmons
University <BR>www.hsutx.edu<BR>PO BOX 16040<BR>Abilene, TX
79698<BR></FONT></P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <B>On Behalf Of </B>Linda
Miller<BR><B>Sent:</B> Wednesday, May 03, 2006 1:55 PM<BR><B>To:</B> Cedarville
DOWNLOAD Users<BR><B>Subject:</B> Re: [Download-List] Using TOTAL
COUNTER<BR></FONT><BR></DIV>
<DIV></DIV>SELECT PAYTODAT WHEN PTD.BD.CODES = 'RRSB''RESB' BY.EXP
PTD.BD.CODES<BR>LIST PAYTODAT TOTAL COUNTER should give you the 99 count
that you are looking for<BR><BR>Minatra, Pat wrote:<BR>
<BLOCKQUOTE cite=mid645EBE386054B0459AA6602C88AE1D09062A06C5@exchange1.hsutx.edu
type="cite"><PRE wrap="">I can do the following:
-----start snip
:GET.LIST SBAB.TOTAL
56 records retrieved to list 0.
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">SELECT PAYTODAT WITH PTD.BD.CODES = "RRSB"
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
56 records selected to list 0.
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">CLS
</PRE></BLOCKQUOTE><PRE wrap=""><!---->:GET.LIST SBAB.TOTAL
56 records retrieved to list 0.
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">SELECT PAYTODAT WITH PTD.BD.CODES = "RESB"
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
43 records selected to list 0.
</PRE><PRE wrap=""><!---->-----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
<A class=moz-txt-link-abbreviated href="http://www.hsutx.edu">www.hsutx.edu</A>
PO BOX 16040
Abilene, TX 79698
-----Original Message-----
From: <A class=moz-txt-link-abbreviated href="mailto:download-list-bounces@cedarville.edu">download-list-bounces@cedarville.edu</A>
[<A class=moz-txt-link-freetext href="mailto:download-list-bounces@cedarville.edu">mailto:download-list-bounces@cedarville.edu</A>] On Behalf Of Minatra, Pat
H.
Sent: Tuesday, May 02, 2006 8:01 AM
To: <A class=moz-txt-link-abbreviated href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</A>
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
<A class=moz-txt-link-abbreviated href="http://www.hsutx.edu">www.hsutx.edu</A>
PO BOX 16040
Abilene, TX 79698
_______________________________________________
download-list mailing list
<A class=moz-txt-link-abbreviated href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</A>
<A class=moz-txt-link-freetext href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</A>
_______________________________________________
download-list mailing list
<A class=moz-txt-link-abbreviated href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</A>
<A class=moz-txt-link-freetext href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</A>
</PRE></BLOCKQUOTE></BODY></HTML>