Split One Record Into Multiple Records

[alsoto]

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 lol).

Any easy way to do this?

Thanks,
Al Soto

[alsoto]

ps Can be an update, doesn't actually need to be an append.+ Reply to Thread