Thanks a lot guys....Duh
(however upon examining the help files, I do not see the requirement of the
parentheses.)
----- Original Message -----
From: Jason Kramer
To: RBASE-L Mailing List
Sent: Tuesday, March 17, 2009 12:36 PM
Subject: [RBASE-L] - Re: Compute - Select
Dear Dick,
Try:
SELECT COUNT (DISTINCT chkdate) INTO vcount FROM emppay WHERE quarter = 4
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
Dick Fey wrote:
I am always amazed at how easy it is to do complicated things in Rbase,
than some silly little command trips you up,
well, me at least.
I need to know how many different dates we paid employees in a quarter (for
941 reporting purposes)
Select count distinct chkdate into vcount from emppay where quarter = 4
Does not work.
Compute vcount as count distinct chkdate from emppay where quarter = 4 Does
not work.
Take out the 'distinct' and they both work.
I am sure my brain is not working this morning, but can't see the forest
for the trees.
Dick Fey
