are these actual duplicates in the table or a result of the query, becuase f the join you've used.
if its a problem in the data, then you need to work out urgently how or why those errors arose and develop a strategy to design it out (usually that means careful choice of primary keys. Too often people using MS Access rely on the default primary key, an autonumber column), often it isn't the best or even 'correct' solution. at worst using an autonumber column instead of what could be a so called 'natural' PK candidate(natural as its an attribute of the data itself, not an artificial construct.
ferinstance say you have two tables (orders and order details)
the PK of orders should be the order number, not an autonumber column (unless you take other steps.)
the PK of the orderdetail column shoudl be a composite of the order n umber and (either a product number or item number), so you cannot order the same product twice in the same order or you cannot have the same detail/item number twice int he same order detail. using an autonumber column here means you would have to do extra work (or defien a unique index on those composite columns) making an autonumber column irrelevant, and not just dangerous.
if its a query problem then examine the join and if you can refine it to do what you want
I'd rather be riding on the Tiger 800 or the Norton