Copying first n records

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
 
M

Mario

I would do that but the number of records to copy are saved in another table
so i have to write a code
 
J

John Vinson

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?
 

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

Need Help with a VBA subroutine 0
Adding data to MS Access from csv file 0
Copy previous record into form field 0
Duplicate Mail Merge Record Every Time 5
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Autonumber field in Excel that behaves the same as Access 0
sqlite-odbc write conflict 2
Merging from an Excel file with graphics 1

Top