You want to use DISTINCT, but depending on the structure of your table
and the exact data you want, the structure of the command will vary.
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of William Brake
Sent: Monday, April 21, 2014 1:23 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - extract unique jobcodes
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.
Thanks,
Bill Brake
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
