running access 2k10, query which is producing multiple duplicate records in the result. Not on all records, just some. I've checked all related tables and there are no duplicates. I've added "Distinct" to the query but no change.
I've attached an rtf doc with the access query and the sql view. Any help greatly appreciated.