Crosstab query blank fields

[livin''''life]

I have scoured the mesage board and was unable to find a solution. Thank you
for taking the time to respond.

I have tables as follows:

tbl_Employee
EmployeeID(pk)
LastName
FirstName
etc...

tbl_Training
ClassID(pk)
ClassName
etc...

tbl_TrainingComplete
EmployeeID
ClassID
DateComplete
DateEntered
EnteredBy

I have created a crosstab query that shows the Employees down the left side
and the Class along the top with the dates that the training was completed
(last) but it only shows the class name if someone has completed the
training. I would like it to show all classes even if there is nobody that
completed the class. The class list will grow or shrink when training
requirements are added or changed so setting the columns in the crosstab is
not a solution (as I see it. I may be wrong).

Any help would be appreciated. Thank you.

 

[Michel Walsh]

Make an inner join with Training and Employee, to get employee names rather
than their id.

Make an outer join query with the query just created (to be preserved, or
select to show all records from it) and the table of TrainingComplete.

Make the crosstab on that previous query.


Vanderghast, Access MVP

 

[livin''''life]

Thank you for your help, it worked beautifully.

Make an inner join with Training and Employee, to get employee names rather
than their id.

Make an outer join query with the query just created (to be preserved, or
select to show all records from it) and the table of TrainingComplete.

Make the crosstab on that previous query.


Vanderghast, Access MVP