MS Access Query

Is this possible by in MS Acess by VBA?

Input:
------+------+---------+---------+---------+
id1 | id2 | 001.7 | 002.7 | 003.8 |
------+------+---------+---------+---------+
A1 | C1 | 1 | 1 | 2 |
B2 | B6 | 0 | 0 | 1 |
C1 | DW | 1 | 1 | 1 |



Output:

------+------+---------+---------+
id1 | id2 | Date | Tally |
------+------+---------+---------+
A1 | C1 | 001.7 | 1 |
A1 | C1 | 002.7 | 1 |
A1 | C1 | 003.8 | 2 |
B2 | B6 | 001.7 | 0 |
B2 | B6 | 002.7 | 0 |
B2 | B6 | 003.8 | 0 |
C1 | DW | 001.7 | 1 |
C1 | DW | 002.7 | 1 |
C1 | DW | 003.8 | 1 |
.