Hello,
I am new at creating Loops in Access. I want create a new column for each new occurrence of a ID using a loop. If there is a better way to accomplish this I am open to ideas.
Below is what I want to accomplish.
Table A
<tbody>
</tbody>
Output Table
<tbody>
</tbody>
I am new at creating Loops in Access. I want create a new column for each new occurrence of a ID using a loop. If there is a better way to accomplish this I am open to ideas.
Below is what I want to accomplish.
Table A
ID | Exception Id | Exception Date |
ABC | 55576 | 7/4/19 |
XYZ | 32797 | 6/8/19 |
OPQ | 86290 | 4/2/19 |
ABC | 75479 | 12/6/19 |
XYZ | 57580 | 1/18/19 |
XYZ | 17083 | 5/9/20 |
<tbody>
</tbody>
Output Table
ID | EXC1 | EXC2 | EX3 | EXC_DT1 | EXC_DT2 | EXC_DT3 |
ABC | 55576 | 75479 | 7/4/19 | 12/6/19 | ||
OPQ | 86290 | 4/2/19 | ||||
XYZ | 32797 | 57580 | 17083 | 6/8/19 | 1/18/19 | 5/9/20 |
<tbody>
</tbody>