How can I modify this duplicate query to show me the values in this group. Currently I am using this SQL statement. SELECT DateSaved, COUNT(DateSaved) AS Duplicates FROM dbo.eREPORT GROUP BY DateSaved Having Count(DateSaved) &#062;1<BR>For example the result is:<BR>DateSaved Duplicates<BR>9/10/2001 8:37:51 AM 2<BR><BR>Which is good becuase I want this, but I also want the value of the ID field with these duplicates. Everytime I try to remove the group by I get errors.<BR><BR>Jose