I have ms-access table (A) as below, and I want a macro/VBA code that allow me to generate the in between serial number as shown in table (B).
Regards
Table (A) --------------------------------
ID Name Size From To
1 Sarah Umer 3 1 3
2 Tallia Noor 2 4 5
-----------------------------------------
Table (B)--------------------------------
ID Name Size
1 Sarah Umer 1
1 Sarah Umer 2
1 Sarah Umer 3
2 Tallia Noor 4
2 Tallia Noor 5
-----------------------------------------
Regards
Table (A) --------------------------------
ID Name Size From To
1 Sarah Umer 3 1 3
2 Tallia Noor 2 4 5
-----------------------------------------
Table (B)--------------------------------
ID Name Size
1 Sarah Umer 1
1 Sarah Umer 2
1 Sarah Umer 3
2 Tallia Noor 4
2 Tallia Noor 5
-----------------------------------------