Copying records from a table

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

Could you please tell me how I can pull data from one
table to create a new table. I currently have a table
created with 3,400 records. However, I want to pull 500
of these records to create a new table. How would you
suggest I do this.

A appreciate any advice.

Thank you.

Kate
 
This should be pretty easy to do. Just create a make-
table query (go to query on the menu and choose "Make
Table" and then specify the new table name that you
want). If you just want the first 500 records, go to the
query properties and set the "Top Values" field to 500.
If you want to extract records based on certain criteria,
just enter the criteria on the criteria row.
 
Back
Top