Remove duplicates in Access

[vlkc]

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" ?

[Big X]

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.

[NeoPa]

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.