Access '03 dulicate records in query

L

Laura Z

I'm developing a select query from the results of three other queries and
receiving duplicate information. I have a primary key set up and in the
three original queries it is functioning and I do not receive duplicates, but
the "master" query is generating more information than the single queries
contain. I'm NOT at all good with Access, so please help! This is making me
crazy!
 
K

Ken Sheridan

Using the SELECT DISTINCT option will eliminate any duplicates from the
result set of the final query. You can amend it in SQL view or you can
select 'Yes' as the query's 'Unique Values' property in design view.

Ken Sheridan
Stafford, England
 

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

VBA query 4
avoid duplicates on label report? 5
With a Query in Access 2007, How can I Create This Query 3
Importing from Excel to Access 9
Variable Criterion for Query 2
Error: The query cannot be completed 3
Access 03 Removing Records during Query that appear to be duplicat 3
duplicate value error message - new issue 1

Top