Duplicates

[jwrnana]

I have 4-5 tables that have duplicate fields; therefore, when I do a query,
I am told that I have duplicate fields -- which table do I want to use?

My questions -- how do I find the duplicates? There is a duplicate query, I
believe, although I have not attempted this as I do not want to lose any of
the information already set up. When I run this, does it change my original
tables? What happens to the queries already created? Do I have to set up
new queries after the find duplicate query is run? Is it advisable to run
this?

Thank you in advance,
Joy Rose

 

[jwrnana]

Thank you.

Would you please provide the answers to the following?
When I run this, does it change my original tables? What happens to the
queries already created? Do I have to set up new queries after the find
duplicate query is run? Is it advisable to run this?

I have duplicates in field and tables. Is this the same query?
Joy Rose