u should be able to this all in Access. I know you should be able to create a report or a query that will bring back certain fields. i'm not sure how you would then input them into the new table. I will ask a very knowledgeable friend.
I just feel that if you can do it within access, why not?
Actually - do you really need this second database? If you use the report feature in Access, you only have to print certain records, and certain fields - you don't have to print the whole table if you don't want to. Also, when you say 'another database' does it have to be a whole new database, or could it just be a new table, but within the same database?
what i am trying to say is: is the only reason you are doing this so that you can print certain parts of the table, but not all? If so, all you need is the reports thingy - you don't need a second database at all.
Tim