Copy records

[momoko]

Hi,

I need to copy the first 10 records to another table, how can I do that using query.

Thanks,

 

[Mile-O]

By using an Append Query you can set all your criteria. This, of course, is dependant that your criteria only returns the ten records you wish to move.

If so, then set the destination for appended records to the destination table.

If not, then try using DAO or ADO to transfer the relevant 10 records.