[Download-List] Using TOTAL COUNTER

[Minatra, Pat]

Yay!  Thank you Linda!
 
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!
 
Thank you so much for the help, this has solved it!

-------------------------
"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


 

________________________________

From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Linda Miller
Sent: Wednesday, May 03, 2006 1:55 PM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Using TOTAL COUNTER


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/9698e831/attachment.html>