Hi

Both tables are far to large as this is a running system to give a copy, I am just trying to create a query for a report.

Your Select Statement is exactly what I tried, it displays all the information for Masterdefects, includes the columns for results but just gives null values for the result colum set.

Cheers

DJ