Finding records that contain duplicate values

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Duplcate values in 1 field for each customer 1
Form design to add data to 3 tables in "Order Entry" style db 1
Append Non-Duplicate II 2
Duplicate records in a Query 1
basic query help for two linked tables 7
Just so I understand the Query Grid... 1
Trying To Convert Some Code Given To Me In A Previous Answer * HEL 1
Unique Values vs Unique Records 1

Top