Hi all -
New to Access and SQL but was a pro with Paradox.
Was given assignment to create Excel spreadsheet showing which employees had training overdue. I though this would be better for Access and here I am two months later.
My issue:
I have my tables, queries and forms all set up to return employee information (add, change), Operating Procedure information (add, change), and training information (received and due).
My problem is creating a query that will return employees that require training.
The way it's currently set up is if an employee is trained in one procedure, ALL procedures that employee is responsible for also are assigned. I've attached a spreadsheet showing all 5 procedures were assigned the same training date when in reality, only the highlighted yellow was trained.
Is there a way to create a query that states I want everyone in the Employee table with every Operating Procedure assigned to them less what Operating Procedure they were trained on?
The relationship is currently setup where the employee table is a one-to-many relationship with training table.
Any help or advice would be greatly appreciated!
Thanks advance,
BBSky
New to Access and SQL but was a pro with Paradox.
Was given assignment to create Excel spreadsheet showing which employees had training overdue. I though this would be better for Access and here I am two months later.
My issue:
I have my tables, queries and forms all set up to return employee information (add, change), Operating Procedure information (add, change), and training information (received and due).
My problem is creating a query that will return employees that require training.
The way it's currently set up is if an employee is trained in one procedure, ALL procedures that employee is responsible for also are assigned. I've attached a spreadsheet showing all 5 procedures were assigned the same training date when in reality, only the highlighted yellow was trained.
Is there a way to create a query that states I want everyone in the Employee table with every Operating Procedure assigned to them less what Operating Procedure they were trained on?
The relationship is currently setup where the employee table is a one-to-many relationship with training table.
Any help or advice would be greatly appreciated!
Thanks advance,
BBSky
0 commentaires:
Enregistrer un commentaire