Cross tab Question

[Murray Galvin]

I am trying to produce a report which will be a training matrix for
employees. The Row Headings are the employee's name and position, and the
Column Headings are the course name. The data in the grid will be the date
the particular course was taken.
For flexibility, I want to be able to add new courses, and as these are
added the number of columns will increase.

I have created a cross-tab query, which when run produces the desired
results on screen, however I wish to now create a report based on this query
but can't see a way to get the results. This is the SQL of the cross-tab
query :

TRANSFORM First([Training_Matrix Query].Taken_DatePassed) AS
FirstOfTaken_DatePassed
SELECT [Training_Matrix Query].FirstName, [Training_Matrix Query].LastName,
[Training_Matrix Query].Job_PosAbb
FROM [Training_Matrix Query]
GROUP BY [Training_Matrix Query].FirstName, [Training_Matrix
Query].LastName, [Training_Matrix Query].Job_PosAbb
PIVOT [Training_Matrix Query].Course_Name;

and this is the SQL for the query : Training_Matrix Query

SELECT Employees.FirstName, Employees.LastName, Job.Job_PosAbb,
Course.Course_Name, Course.Course_Validity, Taken.Taken_DatePassed
FROM (Job INNER JOIN Employees ON Job.PositionID = Employees.Position) INNER
JOIN (Course INNER JOIN Taken ON Course.Course_ID = Taken.Taken_Course) ON
Employees.EmployeeID = Taken.Taken_Person;


Any help much appreciated

 

[Duane Hookom]

There are a couple samples of crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the Crosstab.mdb.