No, thats the old JOIN standard, have tried that, it doesnt work eighter, its an INNER JOIN, and it seems that Access doesnt accept the use of *= instead, that should make it a LEFT JOIN, support for the older standard SQL queries seem to be on its way out, thanks anyway Tim.
SELECT DISTINCT...