This is a discussion on New to access, training database within the Microsoft Access forums, part of the Question Forums category; I'm fairly new to access but I do have VBA background and some SQL. I have the following tables that ...
I'm fairly new to access but I do have VBA background and some SQL. I have the following tables that I'm trying to work with:
Table1 (Training Completed)
Qualification, Requirement1, Requirement2, Requirement3
Table3 (Training Available)
The Training from table1 and the requirements are all from Training in Table3. Is what I'm trying to do is report as whether an employee passes a qualification meaning that the current_Revision for Requirement1, Requirement2 and Requirement3 are all acounted for in Table1. What would be the easiest way to go about this?