I have a client who has data like this in an access table:
itemID itemName itemQuantity
1 Corvette 1
2 Mustang 2
3 Camaro 5
He wants to append the data to another table so it looks like this:
itemID itemName itemQuantity
1 Corvette 1
2 Mustang 1
2 Mustang 1
3 Camaro 1
3 Camaro 1
3 Camaro 1
3 Camaro 1
3 Camaro 1
He needs it in this format so that he can export it to excel (for some unknown reason).
Is there an easy way to do this?