Duplicate Values in Query

A

AccessIM

Sorry, I have a correction to my post below. I have not done the group by
but I have tried creating a relationship between qryDisciplineLevelAll and
qryDisciplineLevelAll_1 in Design view. This stopped the duplicate records
but returned the incorrect two records.
 

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

Duplicate Values in Query 1
Duplicate records suppressed 7
Deleting Duplicate Records in a Query 5
Access Query - "Duplicate Records Selected" 5
To find duplicate records in a query that is already finding duplicating records 7
Duplicate date records not showing in query. 3
Duplicate Query 7
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top