The deliverable will be a VBA code that takes data from two existing Access tables and creates a related table with combined data.
The two existing tables contain repeated/duplicated data in hundreds of columns. The columns need to be converted to multiple rows in the new table.
The Basics: the two existing tables have a primary key called RUN NUMBER. For each run number there are 35 part numbers, and each part number has a set of quantities (Start, Rejected, Accepted, Shipped).
Right now, all 35 Part Numbers are in one row, with numerous repeated columns for quantities (QTY REJECTED FOR PART NUM 1, QTY REJECTED FOR PART NUM 2, etc.)
I need one table of RUN NUMBERS, with a related table with separate records for all PART NUMBERS and quantity fields. The new related table must contain all the information from both of the previous tables.
## Deliverables
1.) Coder will write the exact VBA code needed to convert my multiple columns into rows in the related table while retaining the original Run Numbers in the original tables.
2.) I will copy and paste code into my database and expect it to fully automate the task of using the data for reports.