I have a database that captures attendance for varies course that we teach. I need to produce a report that will take the data and align it in columns instead of the data in rows.
For Example:
(names of the courses)
Name.....Job Title.....Gen101....Doc101....Spec101....Spec102...total hrs
Deborah...trainer.........YES........NO..........YES...........YES..........6
My report currently has:
Deborah, Trainer
Gen101...yes
Doc101...no
Spec101..YES
Spec102...YES
I have a table of employees, courses information and courses offered. An employee is linked to the courses offered by SS# and the courses offered is linked to Course information by course code. I need to know what training thwy have had over a time period, whether they attended, have not registered and how many hours completed. I need to sort by department and then name.
I have played around with crosstab queries and I can get some of the information but not all.
HELP!!
Deborah
For Example:
(names of the courses)
Name.....Job Title.....Gen101....Doc101....Spec101....Spec102...total hrs
Deborah...trainer.........YES........NO..........YES...........YES..........6
My report currently has:
Deborah, Trainer
Gen101...yes
Doc101...no
Spec101..YES
Spec102...YES
I have a table of employees, courses information and courses offered. An employee is linked to the courses offered by SS# and the courses offered is linked to Course information by course code. I need to know what training thwy have had over a time period, whether they attended, have not registered and how many hours completed. I need to sort by department and then name.
I have played around with crosstab queries and I can get some of the information but not all.
HELP!!
Deborah
