[RBASE-L] - Re: Compute - Select

[Jason Kramer]

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