Thanks everyone. I really appreciate your help. I look good now.

quote:

---

Read this KB for how to remove duplicate records.

http://support.microsoft.com/default.aspx?scid=kb;en-us;139444

---

The article helps if you have...

Sorry my table structure is like this:

SavedID (Increment 1, 1)

Userid (int)

MLSNum (int)

DateInserted (Datetime)

The duplicates are userid, mlsnum.

Could you give an example with this column structure. I just want to make...

quote:

---

You have to either clean up your data or add additional unique column such as identity column to create the constraint. Strongly...