Hello,
Ok I am creating a database for my baseball cards, football, and hockey cards. I have one table that holds all the cards in one table and have a Query that has all baseball cards separated by Year and Card Manufacture. I haven't begun to separate out the hockey and football cards. Would it be possible to have a Queries for Baseball cards then have another list of Queries for the other sports without having them all bunched up into one large list.
My second question is there a way to know when I'm typing in a duplicate card with in the flat that I'm working on. I have 20,000 plus cards so obviously I'm going to have duplicate cards in other locations but would like to combine duplicates in the same flat or book.