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


Reply via email to