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

How can i Eliminate duplicate records from the query

P: 1
Hi all,

i am new to access could any one tell me how can i eliminate duplicate records from the query

Apr 10 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 280
what is defined as a duplicate, is it one field or the whole row

u could try placing DISTINCT or DISTINCTROW after the initial select
select distinct a, b, c from mytable

difference between distinct and distinctrow

distinct: removes records that contains duplicate data in the selected fields
distinctrow: removes on whole record rather than fields
Apr 10 '07 #2

Post your reply

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