Save query as a table

N

Newbie

or . . . .
1) create table with all necessary primary keys and indexes
2) code so that you create a recordset of your query
3) add each record of the recordset to your table

Remember to delete all existing records from the table if you only want the
records in the recordset each time

HTH

Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to have two tables on same line? 1
Excel file won't save to iCloud on Mac 0
sqlite-odbc write conflict 2
Adding data to MS Access from csv file 0
Can I save a sql statement generated by a search form? 1

Top