G
Guest
Hello all -
I have an Access 2003 table that has many records store in it. I need to
export the records from the table into another table. Below are the details.
- I have a record that has an employee id in field 1 (Column 1), another
employee id in field 2 (Column 2), another employee id in field 3 (Column 3),
and another employee id in field 4 (Column 4). There are 10 other fields in
the record.
- I want to take the first employee id, 10 other fields, and create a new
record in another table. Then, take the second employee id, 10 other fields,
and create another new record in the new table. I want to repeat this for the
third and fourth employee ids.
Essentially, I will have four new employee records in the new table from the
one record in the old table.
I know this is going to be a VB module in Access 2003 and the module will be
some kind of complicated loop. How should this module look? I greatly
appreciate all help!
I have an Access 2003 table that has many records store in it. I need to
export the records from the table into another table. Below are the details.
- I have a record that has an employee id in field 1 (Column 1), another
employee id in field 2 (Column 2), another employee id in field 3 (Column 3),
and another employee id in field 4 (Column 4). There are 10 other fields in
the record.
- I want to take the first employee id, 10 other fields, and create a new
record in another table. Then, take the second employee id, 10 other fields,
and create another new record in the new table. I want to repeat this for the
third and fourth employee ids.
Essentially, I will have four new employee records in the new table from the
one record in the old table.
I know this is going to be a VB module in Access 2003 and the module will be
some kind of complicated loop. How should this module look? I greatly
appreciate all help!