Generate in between numbers

[Ihussein]

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
-----------------------------------------

 

[Ihussein]

Thanks u so much, this exactly what I want.

 

[Ihussein]

I have added another field which it's date column, and I want to generate serial only for the records which are having dates and leave the records which have no dates.
Thanks