Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Remove duplicate values?

Author  Topic  u09022001 1 Post Posted - 2001-09-02 : 05:32:56 Hi, I've got an access table, with a load of numbers in it, e.g: DFEE 1001 1001 1003 2053 2053 2055 2055 2056 How can I run an SQL query which would remove those which are duplicates, so from the list above the output would only be 1003 and 2056? Thanks Jim