Select query - want to append to a results table - arrrggghhh

  • Thread starter Thread starter Nozza
  • Start date Start date
N

Nozza

I have a select query to select records in a table. It returns the
correct data.

I want to append this data into another table. I can't figure out how
to do this :(

I've done it before but can't get my head around it now!

Doh!

Help wanted

Thanks

Noz
 
Easiest way is to save your Select query, and build an Append query based on
it.

Once you've saved your Select query, create a new query. From the list of
available tables and queries, select the Select query you just saved and
click on Add. Drag all of the fields into the grid. Select Query | Append
Query... from the menu bar, and supply the name of the table to which you
want to append the data when prompted. When you do that, a new row will
appear in the grid, Append To. Make sure a field name in the table to which
you want to append the data appears on the row under each field. That's it.
 
Easiest way is to save your Select query, and build an Append query based on
it.

Once you've saved your Select query, create a new query. From the list of
available tables and queries, select the Select query you just saved and
click on Add. Drag all of the fields into the grid. Select Query | Append
Query... from the menu bar, and supply the name of the table to which you
want to append the data when prompted. When you do that, a new row will
appear in the grid, Append To. Make sure a field name in the table to which
you want to append the data appears on the row under each field. That's it.
Click to expand...

Thanks for that - it got me there :)

Noz
 
Back
Top