I'm having problems with a cross tab query. The report I'm generating from this crosstab needs to show a list of every employee down the left hand side +some details and then for the colums I want names of training corses the employee's can undertake. Poppulated in the values of the cross tab is going to be pass or fail and an Expiry date. The problem I'm having is that I'm not getting a list of every employee just the ones who have done training and im not getting colum's for training which have had no employee's have taken. Can any one point me in the right direction please.