Okay... i did use your code... and it did produce something... but not quite sure what is produced... i tried a couple of different things to modify to try to get it to work for me... but it wouldn't take out the duplicate entries...
I will post my Query PROC SQL code that came from Enterprise Guide... mabye you can make more sense of what i need to do by seeing the code that is already generated.
%_eg_conditional_dropds(WORK.Query_for_agent_dgas_final);
PROC SQL;
CREATE TABLE WORK.Query_for_agent_dgas_final AS SELECT DISTINCT agent_dgas_final.mod_date,
agent_dgas_final.EMPLOYEE_NUMBER,
agent_dgas_final.First_Name,
agent_dgas_final.Last_Name,
agent_dgas_final.Department,
agent_dgas_final.Agent_Job_Class,
agent_dgas_final.Office_ID,
agent_dgas_final.Supr_ID,
agent_dgas_final.Agent_login,
agent_dgas_final.EMPLOYEE_TYPE,
agent_dgas_final.HIRE_DATE,
agent_dgas_final.TERMINATION_DATE,
agent_dgas_final.CRTD_CMSID
FROM EC100020.AGENT_DGAS_FINAL AS agent_dgas_final
WHERE agent_dgas_final.EMPLOYEE_NUMBER NOT IS NULL AND agent_dgas_final.EMPLOYEE_NUMBER > "000002"
GROUP BY agent_dgas_final.EMPLOYEE_NUMBER
ORDER BY agent_dgas_final.EMPLOYEE_NUMBER, agent_dgas_final.mod_date;
QUIT;
That gives me the list that i need... just gives me about 70-200 entries per agent... versus the one i am looking for. I swear I will learn this backwards and forwards... the language syntax is so much different from access... and its really confusing to me..
Dean
Message was edited by: Dean_Z
Message was edited by: Dean_Z