Hello To ALL,
I have a MS access issue. OK, starting out I will be getting these three files as external excel files for doing something. I guess I will import these excel files as linked tables or something else into access.
My goal – how can I combine these two tables (Group_Entry_tbl and Item_Entry_tbl) into one table within Microsoft Access?
I have currently three tables
Table 1 and 2 have two columns – amtp,amt0 that are specific to a group in group entry tbl and…. Similarly, amtp, amto that are specific to an item in item entry tbl
Table in bullet 3 , list out each group and the items contained within each group so to speak..
Please check the attached excel for more sample data feel….
1. The final table after combining Group_Entry_tbl and Item_Entry_tbl should look like this with all the combined data in it
cutomer custID Grp_Name Grp_ ID item Name item ID amtP amtO
What can I do in Access VBA or access to accomplish this? I am open to any suggestions – if I have to create extra column(s) or whatever to achieve this, I am ok with that :)