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
Want to join with a linked table and still be able to write records 0
Form design to add data to 3 tables in "Order Entry" style db 1
Append Non-Duplicate II 2
Identify occurences that occur after a date but not before 1
multiple records from one 1
Find duplicates in two tables, report one of them, and keep unique entries 0
basic query help for two linked tables 7

Top