Hi 



I am not too hot on access however i have created a database that has the 

following information Company Name, Email, Telephone, Contact etc and the 

problem i face is that i get a alot of duplicate enteries.



Does anyone know how I can remove any duplicate enteries ?

Put an index on the field(s) that you don't want to be duplicated.



-----Original Message-----

From: pritesh_b@t... [mailto:pritesh_b@t...]

Sent: Monday, May 14, 2001 2:58 PM

To: Access

Subject: [access] Can I do the following in access





Hi 



I am not too hot on access however i have created a database that has the 

following information Company Name, Email, Telephone, Contact etc and the 

problem i face is that i get a alot of duplicate enteries.



Does anyone know how I can remove any duplicate enteries ?

Before addin the index to your field run a find duplicate query so you can 

find the duplicates before you 'll get a warning by Access that you cannot 

place an index on a fiedl that have duplicate values.  You can use the 

Query Wizard to make your Duplicate Query Search.



Derrick A. Flores

Associate Systems Engineer

6" Line Engineering

Sony Electronic Inc.

Semiconductor San Antonio

1 Sony Place M/S 730

San Antonio, Texas 78245-2100

Telephone:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx

Pager:  (xxx) xxx-xxxx

E-mail: derrick_flores@s...



>>> "Levine, Lloyd" <LEVINLL@m...> 05/14 1:14 PM >>>

Put an index on the field(s) that you don't want to be duplicated.



-----Original Message-----

From: pritesh_b@t... [mailto:pritesh_b@t...]

Sent: Monday, May 14, 2001 2:58 PM

To: Access

Subject: [access] Can I do the following in access





Hi



I am not too hot on access however i have created a database that has 

the

following information Company Name, Email, Telephone, Contact etc and 

the

problem i face is that i get a alot of duplicate enteries.



Does anyone know how I can remove any duplicate enteries ?

Sounds like a problem with your table structure. How many tables does your 

database contain, and what are their names? Also, what are the names of 

each field in each of your tables? You may need more tables than you're 

currently working with. What does "I get a lot" mean? You have to enter a 

lot, or you get a lot after running, say, a query? Be more specific if you 

can.



> Hi 

> 

> I am not too hot on access however i have created a database that has 

the 

> following information Company Name, Email, Telephone, Contact etc and 

the 

> problem i face is that i get a alot of duplicate enteries.

> 

1) Did you set up your indexes correctly?

2) Do you know how to set up your indexes correctly?

3) Did you set up your Relationships correctly?

4) Do you know how to set relationships?



Just some problems which could allow duplicate entries to accumulate.



_____________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209

________________________________________

If these are true duplicates (e.g., every field is exactly identical), then

you can dump them easily in a query.  Just start up a new select query, add

the fields you want to select on, and go to SQL view.  Then add the word

DISTINCT after the SELECT statement and run the query--you shouldn't see any

dupes.  If that looks good to you, change it to a make-table query and then

replace your original table with the new one.



The more common problem is with records that are not exactly

duplicates--e.g., one record is John Smith from "Acme Incorporated", and the

other is for John Smith from "Acme Inc.".  That's not easy to get around

programmatically--it's more a job for a human being...



HTH,



-Roy





-----Original Message-----

From: pritesh_b@t... [mailto:pritesh_b@t...]

Sent: Monday, May 14, 2001 11:57 AM

To: Access

Subject: [access] Can I do the following in access





Hi 



I am not too hot on access however i have created a database that has the 

following information Company Name, Email, Telephone, Contact etc and the 

problem i face is that i get a alot of duplicate enteries.



Does anyone know how I can remove any duplicate enteries ?

You don't even need to do this in the SQL view. Just pull up the properties

of the query while in design view and change "unique values" or "unique

records" to "yes". Make sure you don't have one of the fields selected, or

you'll pull up the property sheet for that field (or table). Click on the

background area in design view and you should get the General tab for that

particular query.



Janan Zonker

Analyst/Programmer

Faculty Affairs and Records

Cal State Fullerton





-----Original Message-----

From: Pardee, Roy E [mailto:roy.e.pardee@l...]

Sent: Thursday, May 17, 2001 1:36 PM

To: Access

Subject: [access] RE: Can I do the following in access





If these are true duplicates (e.g., every field is exactly identical), then

you can dump them easily in a query.  Just start up a new select query, add

the fields you want to select on, and go to SQL view.  Then add the word

DISTINCT after the SELECT statement and run the query--you shouldn't see any

dupes.  If that looks good to you, change it to a make-table query and then

replace your original table with the new one.



The more common problem is with records that are not exactly

duplicates--e.g., one record is John Smith from "Acme Incorporated", and the

other is for John Smith from "Acme Inc.".  That's not easy to get around

programmatically--it's more a job for a human being...



HTH,



-Roy





-----Original Message-----

From: pritesh_b@t... [mailto:pritesh_b@t...]

Sent: Monday, May 14, 2001 11:57 AM

To: Access

Subject: [access] Can I do the following in access





Hi 



I am not too hot on access however i have created a database that has the 

following information Company Name, Email, Telephone, Contact etc and the 

problem i face is that i get a alot of duplicate enteries.



Does anyone know how I can remove any duplicate enteries ?