Here is my DB attached, I am generating a database for keeping a record of aircraft maintenance engineers, which come in A, B & C categories. They need to undertake exams P1,P2,P3,P4......, more than a dozen in each category. Now what I want is a Form Query named "My Query" in my database, where I have the option to select people as per my selection criteria.
Selection Criteria can be one Category (A) or two Categories (A And B), similarly, exam status such as Pass Or Fail, or Pass And Fail for each exam P1,P2,P3,..........P15, as people can take one exam multiple times if they fail it. At the end, which exams, such as P1 And P2 And P3 And P4 And..... are passed by whom?
Please help!