create a table with duplicates from a query

B

BrightIdeas

Hi.
I want to return records in a query in the order of my criteria. I have
some duplicates.
For example 3,4,5, 4,3,2, 45,44,43

Access is returning the records but omitting the duplicates which I
want in the new table as well.
 
D

David F Cox

One has to ask the obvious question: Does one of the fields have no
duplicates set in the table definition, or is defined as the Key?
 

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

Combine Duplicates in Query 0
duplicates query 2
deleting duplicate records obtained from a duplicate query 4
remove duplicate records in Access 2007 7
Duplicate Values in Query 1
Duplicates in union query 3
Duplicate Query based on two duplicates 7
Deleting duplicate records 3

Top