I have an access table that contains data similar to the first table below. (There is more but I don't need it for this part)
I'm trying to come up with a way to copy the information from this table and append it in another table. But the additional Fig and Additional Item data has been moved then separated into the Fig and Item. The MasterNum will link them to record in original table.
Also, if a FIG or ITEM is blank then 9999 is add to the record. And sometimes there is an Additional FIG that does not have a matching Additional Item (for example, for MasterNum 88 there are there Additional Fig but only two Additional Item. The Additional Item associated with 157 will be 9999 since it does not exist.)
Please let me know if I'm making any sense.
I have only started thinking about doing so I do not have any code to share.
Does someone know of some code I can modify to accomplish this task or point me in the direction of some info on how to do this.
Thanks
MasterNum | FIG | ITEM | Additional Fig | Additional Item |
88 | BULK | 24 | 130, 155, 157 | 22, 6 |
89 | 4-2 | 25, 212 | 11, 14 |
I'm trying to come up with a way to copy the information from this table and append it in another table. But the additional Fig and Additional Item data has been moved then separated into the Fig and Item. The MasterNum will link them to record in original table.
Also, if a FIG or ITEM is blank then 9999 is add to the record. And sometimes there is an Additional FIG that does not have a matching Additional Item (for example, for MasterNum 88 there are there Additional Fig but only two Additional Item. The Additional Item associated with 157 will be 9999 since it does not exist.)
Please let me know if I'm making any sense.
MasterNum | Fig | Item |
88 | BULK | 24 |
88 | 130 | 22 |
88 | 155 | 6 |
88 | 157 | 9999 |
89 | 212 | 14 |
89 | 4-2 | 9999 |
89 | 25 | 11 |
89 | 212 | 14 |
I have only started thinking about doing so I do not have any code to share.
Does someone know of some code I can modify to accomplish this task or point me in the direction of some info on how to do this.
Thanks