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..........Y ES...........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

You can only get one piece of information from your crosstab. Therefore, if you need more than one, create additional crosstabs and join them. Use the final query that joins all the crosstabs as the recordsource for the report. You'll need to rename the columns in the join query to coorespond with what was returned by each crosstab.