By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,437 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

How do you query a table without duplicates in access

P: 6
I've got a table with duplicates, and I want to query the table without duplicates.
my table :HOUSE

column : Name
col2 :DOA
col3 : Postcode

How is it done?
Sep 14 '07 #1
Share this Question
Share on Google+
2 Replies


P: 2
I've got a table with duplicates, and I want to query the table without duplicates.
my table :HOUSE

column : Name
col2 :DOA
col3 : Postcode

How is it done?
If the duplicates are identical, i.e. the duplicated names are identical, then all you have to do is click on the Totals button on the toolbar in your query. Ensure that the TOTAL field is set to 'Group By' for your Name field.
Sep 14 '07 #2

P: 6
gpo
Thanks for your effort, But I have tried the method with no joy!
my sql query is SELECT DISTINCT column FROM TABLE .
Why does this syntax work in access or is there a better sql cmd?
Sep 14 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.