De-duplicating data column

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have a column of values in a table of which some are duplicate. How can I
remove the duplicates such that no value is duplicate in the column?

Thanks

Regards
 
On Fri, 9 Jan 2009 05:38:47 -0000, "John" <[email protected]>
wrote:

select distinct YourColumnName
from YourTable
You can use this as the basis of a new MakeTable query.

That's the simple answer. In real-world situations it can be much more
complicated, and you will often have to decide which of the rows you
want to keep, looking at the values of other columns, and sometimes
other tables.

-Tom.
Microsoft Access MVP
 
Back
Top