[RESOLVED] Whats the SQL (Access) statement to eliminate

Avoid using DISTINCT simply to knock out duplicates.. figure out why they are there in the first place and be more careful with your joins..

Using DISTINCT carelessly causes poor performance, because you effectively ask the database to join two tables, and (because you didnt specify the join very well) it generates, say, 200,000 records. You then ask it to knock out repeated rows with distinct, and it reduced this to 50,000. If you specify the joins correctly initially, then the database only works to generate 50,000 rather than generate then remove 150,000 useless ones.