De-duplicating data column

[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

 

[Tom van Stiphout]

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