Removing field data within a Query
Posted on 2012-03-27
I have created the query below to give me the sum of use within each job code. Each Job Code begins with 4 numbers and some are followed by letters. What i need to do is eliminate the letters so those combine reducing my final results. Below is my SQL and a sample of the job codes.
SELECT employeeinfo.JOBCODE, Sum(dragon.TotalDuration)/360 AS SumOfTotalDuration
FROM dragon INNER JOIN employeeinfo ON dragon.LastLoginName = employeeinfo.LOGNAME
GROUP BY employeeinfo.JOBCODE
HAVING (((Sum(dragon.TotalDuration)) Is Not Null));
Job Code Ave Utilization