Hi to all,
Need help to compare 2 tables, REQUIRED vs PROVIDED.
Please refer to the attached image, the scenario is SOA NO from REQUIRED ex. 1.1.01.1.01 has been split into many in the PROVIDED ex. 1.1.01.1.01(1) , 1.1.01.1.01(2) , 1.1.01.1.01(3) etc. as indicated by the numbers inside the bracket, furthermore, there have been variations like ex. 1.1.01.1.01(1).CIR and 1.1.01.1.01(1).A
If you will look at the image, the excel on top has 2 parts, left as required & right side as provided, we where able to compare how many split rooms of a given required SOA NO and also the variations using a script, we would like to do that in access.
Hope somebody in these community can shed light.
Thanks to all.
Need help to compare 2 tables, REQUIRED vs PROVIDED.
Please refer to the attached image, the scenario is SOA NO from REQUIRED ex. 1.1.01.1.01 has been split into many in the PROVIDED ex. 1.1.01.1.01(1) , 1.1.01.1.01(2) , 1.1.01.1.01(3) etc. as indicated by the numbers inside the bracket, furthermore, there have been variations like ex. 1.1.01.1.01(1).CIR and 1.1.01.1.01(1).A
If you will look at the image, the excel on top has 2 parts, left as required & right side as provided, we where able to compare how many split rooms of a given required SOA NO and also the variations using a script, we would like to do that in access.
Hope somebody in these community can shed light.
Thanks to all.