How to delete duplicates registers in Acces 2.003

[Guest]

How to delete duplicates registers in Acces 2.003 ?
I Know in Acces 2.002 but I dont know in Acces 2.003.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-bf20-8cca38ac4eab&dg=microsoft.public.access

 

[Graham Mandeno]

I think you mean duplicate *records*, not *registers*. I believe online
translators commonly translate the Spanish word for "record" to "register".

The methods for querying duplicate records, or for eliminating duplicates
from queries, have not changed between Access 2002 and 2003. Would you care
to tell us the method you use in 2002 which does not work in 2003?

 

[Guest]

Graham, thank you for your answer.
When I make a consult whith Office Assistant in Acces 2.002 I can choose
duplicate records, but not in Acces 2.003.
My data base has only one table whith 3 columns. Im trying to make a
dicctionary Inghis-Spanish-Bosnian from diferents data bases, so I got a lot
of duplicates records.
Could you tell me step by step how can I delete this duplicates onces in a
time?
Thanks again.

I think you mean duplicate *records*, not *registers*. I believe online
translators commonly translate the Spanish word for "record" to "register".

The methods for querying duplicate records, or for eliminating duplicates
from queries, have not changed between Access 2002 and 2003. Would you care
to tell us the method you use in 2002 which does not work in 2003?
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

How to delete duplicates registers in Acces 2.003 ?
I Know in Acces 2.002 but I dont know in Acces 2.003.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-bf20-8cca38ac4eab&dg=microsoft.public.access

 

[Graham Mandeno]

A "consult"? I guess you mean a "query"

I don't know why the query wizard is not working - maybe the option to
install standard wizards was not selected when Access was installed.

No matter - it is easy to do without the wizard.

Create a normal query based on your table and add all three fields to the
grid. For each one, set "Sort" to "Ascending".

Now, for the first field, set the "Criteria" to:

In (SELECT [Field1] FROM [YourTable] As T
GROUP BY [Field1],[Field2],[Field3]
HAVING Count(*)>1
And T.[Field2] = [YourTable].[Field2]
And T.[Field3] = [YourTable].[Field3])

You must change "YourTable" to the name of your table, and change Field1,
Field2, and Field3 to the names of your three fields.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Graham, thank you for your answer.
When I make a consult whith Office Assistant in Acces 2.002 I can choose
duplicate records, but not in Acces 2.003.
My data base has only one table whith 3 columns. Im trying to make a
dicctionary Inghis-Spanish-Bosnian from diferents data bases, so I got a
lot
of duplicates records.
Could you tell me step by step how can I delete this duplicates onces in a
time?
Thanks again.

I think you mean duplicate *records*, not *registers*. I believe online
translators commonly translate the Spanish word for "record" to
"register".

The methods for querying duplicate records, or for eliminating duplicates
from queries, have not changed between Access 2002 and 2003. Would you
care
to tell us the method you use in 2002 which does not work in 2003?
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

How to delete duplicates registers in Acces 2.003 ?
I Know in Acces 2.002 but I dont know in Acces 2.003.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-bf20-8cca38ac4eab&dg=microsoft.public.access

 

[Guest]

Yes, is better "query" than "consult", sorry about my english.
Thanks again for your answer. It works perfectly. thank you very much.

A "consult"? I guess you mean a "query"

I don't know why the query wizard is not working - maybe the option to
install standard wizards was not selected when Access was installed.

No matter - it is easy to do without the wizard.

Create a normal query based on your table and add all three fields to the
grid. For each one, set "Sort" to "Ascending".

Now, for the first field, set the "Criteria" to:

In (SELECT [Field1] FROM [YourTable] As T
GROUP BY [Field1],[Field2],[Field3]
HAVING Count(*)>1
And T.[Field2] = [YourTable].[Field2]
And T.[Field3] = [YourTable].[Field3])

You must change "YourTable" to the name of your table, and change Field1,
Field2, and Field3 to the names of your three fields.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Graham, thank you for your answer.
When I make a consult whith Office Assistant in Acces 2.002 I can choose
duplicate records, but not in Acces 2.003.
My data base has only one table whith 3 columns. Im trying to make a
dicctionary Inghis-Spanish-Bosnian from diferents data bases, so I got a
lot
of duplicates records.
Could you tell me step by step how can I delete this duplicates onces in a
time?
Thanks again.

I think you mean duplicate *records*, not *registers*. I believe online
translators commonly translate the Spanish word for "record" to
"register".

The methods for querying duplicate records, or for eliminating duplicates
from queries, have not changed between Access 2002 and 2003. Would you
care
to tell us the method you use in 2002 which does not work in 2003?
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

How to delete duplicates registers in Acces 2.003 ?
I Know in Acces 2.002 but I dont know in Acces 2.003.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-bf20-8cca38ac4eab&dg=microsoft.public.access