Finding records that contain duplicate values

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have a table called Orders. It contains Fields called
CustId, OrderNumber, OrderDate, ShipDate amongst many
other fields.

I need to find Only the records that contain Duplicate
Values in the OrderDate Field for each CustId.

i.e. If CustID #001 has two records with an Order Date od
12/01/03 then both records are displayed. If a CustID
does not have a matching record with the same Order Date
then No records are displayed.

Any help would be appreciated. Thank you.
 
Back
Top