Help with duplicate query

[espinobj]

SELECT Master.[Cable ID], Master.[Main S/N], Master.Date, Master.Time, Master.[Length Feet], Master.Floor, Master.Closet, Master.Rack
FROM Master
WHERE (((Master.[Cable ID]) Not Like "*TRC*") AND ((Master.[Media Type])<>"Twisted Pair")) AND 
((Master.[Main S/N]) In (SELECT [Main S/N] FROM [Master] As Tmp GROUP BY [Main S/N],[Date],[Time] HAVING Count(*)>1  And [Date] = [Master].[Date] And [Time] = [Master].[Time]))
ORDER BY Master.[Main S/N], Master.Date, Master.Time;

I need some assistance. Im still very new to SQL. This shows me duplicated for our results that match based on Date, Time and Main S/N. They must match all 3 in order to be considered a duplicate. My results only show one of the two duplicates which is great as I know I have an issue however I need to see both results not just one. Can I get some help Thank you!

[aytee111]

This will show all duplicates with the criteria you have. Show us all records so that we can see why only the one is being displayed, and what could possibly be causing the exclusion.