How to check "repeated data"???

[sammx]

HI All,
I build a textbook database which contains Title, Author, ISBN, etc...
Since there are thousands of textbooks, it is highly possible to input the same textbook into the database. Therefore, there could be some "exactly the same" data in this database.
My question is: is there a way that I can check whether there are same ISBNs in my database?
For example, there are 10000 records in my database. There are two records with the same ISBN. Can I observe this problem somehow?
Thanks!

 

[cheerio]

If ISBN is set up as the primary key then Access will not permit duplicate entries.

Before you can do this you need to identify the duplicates. Access has a find duplicates query wizard that can be used to do this. The wizard is not always installed if you have a minimal installation, in which case you need to return to the set-up disk.

Ken

 

[thornmastr]

The following SQL will tell you if you have duplicated ISBN’S.

SELECT ISBN, Count(ISBN) AS ISBNCOUNT FROM YOURTBL
GROUP BY ISBN HAVING Count(ISBN)>1

Once you have deleted all duplicate entries, establish ISBN as a key which does not allow duplicates.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com