I have a table of employees. I have a table of courses by level, category and courses i.e., Level 1, (Category) Human Resourses, (Courses) Performance Management & Compensation and Benefits. Then I have a table that shows each employee, the courses they've taken and if they passed or failed.
I created a form that has a combo box lookup, so that the user can either type or hit the drop down to look up a paticular employee. Then the form will bring up that employee's information, like Division, Location etc. I put a command button on this form that takes me to another form that shows all the Categories and Courses (within ea. category) AND everything on this form is just for Level 1. I'll make a separate form for Level 2 and Level 3. This form is created from a query that has been copied with the criteria changed for each Category so only the courses for that particular catetory show up. Another words, on the form, I have a Label Called HR. Next to that a Unbound text box that has a query for the Record Source, and it's criteria is only the HR courses. Then the next Category Label is listed with another Unbound text box using the same query in the Record Source, except the criteria is changed for that particular category, and so forth down the form.
What I am trying to accomplish is to add the pass/fail results by employee by course. I've tried adding it to the query in the Unbound text boxes that list the courses for each category; and I've tried adding another Unbound text box next to each course with an IIF statement. None seem to work. I'll show an example below:
Employee Name: Joe Schmoo
Human Resources: Performance Management Completed
Compensation & Benefits Needed
Leadership: Conflict Resolution Needed
Speaking/Presentations Completed
(etc)
I hope this all makes sense. I've tried posting this question with less detail, but I can't seem to explain it correctly that way. Thank you for your help.
P.S. I'm not very familiar with writing code or SQL.
Thank,
CindiN
I created a form that has a combo box lookup, so that the user can either type or hit the drop down to look up a paticular employee. Then the form will bring up that employee's information, like Division, Location etc. I put a command button on this form that takes me to another form that shows all the Categories and Courses (within ea. category) AND everything on this form is just for Level 1. I'll make a separate form for Level 2 and Level 3. This form is created from a query that has been copied with the criteria changed for each Category so only the courses for that particular catetory show up. Another words, on the form, I have a Label Called HR. Next to that a Unbound text box that has a query for the Record Source, and it's criteria is only the HR courses. Then the next Category Label is listed with another Unbound text box using the same query in the Record Source, except the criteria is changed for that particular category, and so forth down the form.
What I am trying to accomplish is to add the pass/fail results by employee by course. I've tried adding it to the query in the Unbound text boxes that list the courses for each category; and I've tried adding another Unbound text box next to each course with an IIF statement. None seem to work. I'll show an example below:
Employee Name: Joe Schmoo
Human Resources: Performance Management Completed
Compensation & Benefits Needed
Leadership: Conflict Resolution Needed
Speaking/Presentations Completed
(etc)
I hope this all makes sense. I've tried posting this question with less detail, but I can't seem to explain it correctly that way. Thank you for your help.
P.S. I'm not very familiar with writing code or SQL.
Thank,
CindiN