Saving selected records of query into new database

[tomcat]

Hello,

Let's say I run a search query (type a word in, search results bring up 10
items, which I have already working fine).
I would like to save two or three of the search results records into a new
or an already created empty table, then do another search and grab maybe one
of the records of the search and add them to that same table and so on until
I'm done searching for the items I need. How is this done if it is possible
at all in Access? An append query sends ALL of the results of the search
query to the table. Again, I only need to send some.

What I really would like to do is grab the two or three records and dump
them in an Excel sheet, do another search and dump some of the new search
result records in that same Excel document and so on until I have my list
ready. I did this but when I paste to Excel, the column headings are
included everytime I paste a set of records. That's why I thought if I can
throw everything in a table I can then send/paste the whole new table (the
one with the records selected in the multiple search querys I ran) into an
Excel sheet and have just one row of headings.

Anyways, any help will be immensely appreciated.

 

[John Vinson]

Hello,

Let's say I run a search query (type a word in, search results bring up 10
items, which I have already working fine).
I would like to save two or three of the search results records into a new
or an already created empty table, then do another search and grab maybe one
of the records of the search and add them to that same table and so on until
I'm done searching for the items I need. How is this done if it is possible
at all in Access? An append query sends ALL of the results of the search
query to the table. Again, I only need to send some.

What I really would like to do is grab the two or three records and dump
them in an Excel sheet, do another search and dump some of the new search
result records in that same Excel document and so on until I have my list
ready. I did this but when I paste to Excel, the column headings are
included everytime I paste a set of records. That's why I thought if I can
throw everything in a table I can then send/paste the whole new table (the
one with the records selected in the multiple search querys I ran) into an
Excel sheet and have just one row of headings.

A new table is unnecessary. I'd suggest adding a Yes/No field Selected
to your table. You can then simply go down a continuous Form or a
datasheet, selecting the records to export to Excel by checking the
checkbox.

You can then use File... Get External Data... Link to *link* to the
Excel spreadsheet, and run an Append query selecting only those
records with [Selected] = True into the spreadsheet.

To start over with a different subset, run an Update query updating
[Selected] to False with a criterion of [Selected] = True, to get back
to a clean slate.

John W. Vinson[MVP]