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

Remove duplicates in Access

P: 1
Hi,

i have this database:

1 one
2 one people have
3 people one have
4 people have

how can i remove duplicated rows with word "one" ?
Aug 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: 42
I'm not sure what your access experience is. But try creating a query
for that field with the following criteria

put into Criteria one
put into or like *one
put into or like one*

That should produce them all in a query then you should be able to select them all and hit delete.
Aug 28 '08 #2

NeoPa
Expert Mod 15k+
P: 31,475
Hi,

i have this database:

1 one
2 one people have
3 people one have
4 people have

how can i remove duplicated rows with word "one" ?
What do you mean by duplicated? There appear to be no duplicated rows in your example data.
Aug 30 '08 #3

Post your reply

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