duplicates

[bladeap]

I just started using Access a few months ago, while helping a boss at work update a rather large database. So I'm not very well versed in it.

I have a table with 1810 entries. There definitely were duplicates within it. I found this out when I ran a query to check if there was. I saved the results in another table and it showed that I now had 1702 entries. I've tried running another query to find out what those 108 entries are, but nothing seems to work. I also am having a problem of not being able to make a field called 'Identification Number' my primary key. Nothing seems to work!

Sadly, I just got this error in addition to my woes: "The Microsoft Access database engine could not find the object....."

Can anyone help?

[Siiig]

I just started using Access a few months ago, while helping a boss at work update a rather large database. So I'm not very well versed in it.

I have a table with 1810 entries. There definitely were duplicates within it. I found this out when I ran a query to check if there was. I saved the results in another table and it showed that I now had 1702 entries. I've tried running another query to find out what those 108 entries are, but nothing seems to work. I also am having a problem of not being able to make a field called 'Identification Number' my primary key. Nothing seems to work!

Sadly, I just got this error in addition to my woes: "The Microsoft Access database engine could not find the object....."

Can anyone help?

This may help you out with finding the duplicates...

In (SELECT [Duplicate] FROM [Table] As Tmp GROUP BY [Duplicate] HAVING Count(*)>1 )

Add this to the column with the appropriate fields filled above.