Copying first n records

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

I have 150 records in one table
I want to copy first 120 records from this table to another
How do I do that? I need a code in VBA. thnx
 
I would do that but the number of records to copy are saved in another table
so i have to write a code
 
I have 150 records in one table
I want to copy first 120 records from this table to another
How do I do that? I need a code in VBA. thnx
Click to expand...

"First" in what sense? A Table is an unordered "bag" of data. Do you
have some criteria within the record to identify the first 120, or is
it ok to take an uncontrolled and arbitrary 120 records in disk
storage order, being aware that Access does NOT necessarily store
records in the order that they were added?
 
Back
Top