Filter & Calculate sums

[jkbear]

I have a table which lists employment history of job applicants. It has fields for "Name," "Position," "StartDate," and "EndDate." This information is displayed in an applicant form, sorted by "Name." Each applicant may have multiple positions and multiple instances of the same position. How do I display a summary of the positions showing how many years experience the applicant has in each position listed.

 

[MajP]

SELECT 
 tblEmployment.Name, 
 tblEmployment.position, 
 Sum(Round(DateDiff("m",[tblEmployment]![startDate],[tblEmployment]![endDate])/12,1)) AS TimeInPos
FROM 
 tblEmployment
GROUP BY 
 tblEmployment.Name, 
 tblEmployment.position;