Making a duplicate copy of a table in ACCESS 2000

Question

I created a database of books in a private library as it was being organized. Thus, many of the books turned out to be duplicate copies, which I noted in a field "Notes" along with other extraneous info that turned up. The duplicate books were culled and stored elsewhere. I managed to create a copy of the database, that contained just the duplicated books (or most of them) to use when consolidating these duplicate books at a later time. I have now gotten the multiple copies together in specific locations and entered this data into the original table, but would like to create a new table of just these duplicate books. I can't remember how I did it. Export doesn't work, as it wants the database file already created. Query/report doesn't suit, as I want to be able to add information into the records. Re-entering the data into the copy I created previously seems to defeat the purpose of having the database in the first place.

Did I miss something in the use of a database that would have allowed this?  Can I rectify it at this point? Or can someone help me to remember how I did the copy in the first place?

Answer 1

 Is that the menu? If, so, which one, where?  I have tried this several times, with and without wizard and see no opportunity to do any of the things you mention.  Maybe Access 2000 doesn't do it, but later versions do?

Use the steps depicted below --

Answer 2

Your process and requirement is not clear.  

Do you now have one table that contains all with a field indicating duplicates?  If you want a table with just the duplicate the use a make table query with criteria of duplicate.

Answer 3

I have since learned that simply highlighting the table's title and doing a Ctrl C, then Crtl V does the job. Then I have to delete the records I don't want to include. Not sure that's how I did it originally, but it works.

Yes, I have one table. No, there is not a field indicating duplicates, but a query has successfully sorted for any use of the word "duplicate" in the field Notes. Thus, I end up with a Report, rather than a Table, but perhaps a Report is as searchable as I need?  

So perhaps the question becomes whether or not it is possible to add a field or two to the original table at this late date? For example, CopyCount, and input the number of copies, then make a query that sorts out any books with more than 1 in that field?  Or maybe DuplicateLocation and then sort for any records that do not have a Null value in that field?  Either way, I don't see how I get a table, rather than a report.

Answer 4

When you create a query in design view there are options in the ribbon for SELECT, MAKE TABLE, APPEND, UPDATE, etc.  you would create the query as SELECT and then change to Make TABLE.

Answer 5

When you create a query in design view there are options in the ribbon for SELECT, MAKE TABLE, APPEND, UPDATE, etc.  you would create the query as SELECT and then change to Make TABLE.

 Is that the menu? If, so, which one, where?  I have tried this several times, with and without wizard and see no opportunity to do any of the things you mention.  Maybe Access 2000 doesn't do it, but later versions do?