At 01:23 PM 4/21/2014, William Brake wrote:
What is the command or function that will retrieve or extract a list of unique jobcodes from a table of time data. There are several thousand time records that are distributed over a couple hundred jobcodes. I just need a print out of all the jobcodes. I've done something like this in the past but can't lay my eyes on it now.
Bill, -- Example 01 SELECT DISTINCT JobCodes FROM TimeData -- Example 02 SELECT JobCodes FROM TimeData GROUP BY JobCodes -- Example 03 TALLY JobCodes FROM TimeData Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
