Duplicate Records in Access table
Posted on 2007-11-28
I've an Access table with 3 Columns. Location, Title, BookID.
Each Location can store multiple copies of the same title.
Similarly same title can be stored at multiple locations.
Now I need three quires.
1. All Titles with more than 1 copy.
2. All Titles with more than 1 copy from a particular location only.
3. Those titles ONLY found at different locations.
Consider following data
East, Book A, 1111
East, Book A, 2222
East, Book B, 3333
West Book C, 5555
Central, Book C, 666
Central, Book D, 777
Query 1 Should return Book A, Book C
Query 2 Should return Book A (For Location East)
Query 3 Should return Book C
I'he managed with first 2. The last one was a bit tricky.
Any help would be appreciated.