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.
 
Stephen

Have you looked into using the Query Wizard, for duplicates?
 
You must log in or register to reply here.

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
Selecting unique records based on one field 3
Selecting desired value in totals query 4
Add a column to a query (the value of the column needs calculation 2
Help for finding customers with no orders query. 8
Invalid use of Null (You'll be sent to Guantanamo Bay!) 3
Finding records with no entry within past year 4
how to have a form that generate invoice no. 2

Back
Top