This?
Code:
SELECT Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([Table1.Name],"Â",""),"Ã",""),"¬",""),"¢",""),"„",""),"â",""),"'","\'"),'"',"") AS product, Manufactures.Mid, Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([Description],"Â",""),"Ã",""),"¬",""),"¢",""),"„",""),"â",""),"'","\'"),'"',"") AS [desc], Categories.cid
FROM (Manufactures INNER JOIN Table1 ON Manufactures.[Name] = Table1.[Manufacture]) INNER JOIN Categories ON Table1.[Category] = Categories.[name]
WHERE ((Not (Manufactures.Mid)=0) AND (Not (Categories.cid)=0));