Hello,
I have a database where I am tracking employee training along with the curricula assigned to each job function. I have successfully created tables and queries to document the training events themselves, but where I am struggling is creating a query showing the training progress as it relates to the assigned items.
In the query I have been able to show the employee and the training requirements assigned to them, but if an employee has more than one job function assigned to them, the same requirement may be assigned multiple times. I only need to see it once. Everything I've found talks about removing duplicates, but they are not true duplicates since one of the fields is different.
I have attached an image of the current query design. Of the 'duplicate data' the only field that is different is the JobTitle with the potential for Department to be different as well - all the others would be the same.
How can I get the query to only show one record per employee and SOPNumber?
Thank you!
I have a database where I am tracking employee training along with the curricula assigned to each job function. I have successfully created tables and queries to document the training events themselves, but where I am struggling is creating a query showing the training progress as it relates to the assigned items.
In the query I have been able to show the employee and the training requirements assigned to them, but if an employee has more than one job function assigned to them, the same requirement may be assigned multiple times. I only need to see it once. Everything I've found talks about removing duplicates, but they are not true duplicates since one of the fields is different.
I have attached an image of the current query design. Of the 'duplicate data' the only field that is different is the JobTitle with the potential for Department to be different as well - all the others would be the same.
How can I get the query to only show one record per employee and SOPNumber?
Thank you!