This should be real easy to do, Why can't I figure it out???

I have a querey that gets information from a few tables. As a result, some information in the table is duplicated.

How do I eliminate the duplicates?

I tried making a blank table where one field is indexed (No duplicates) but that elinates some records entirely (haven't figured out why).

Any help?