Duplicating Records

[Jim]

I have an order line item table with an auto number and
Qty Sold fields. What I want to do is duplicate the
record based on the value in the Qty field and then set
the Qty for that record to 1 (or zero if that is easier).
For example if record 1 had a Qty of 1 (or zero) do
nothing, Qty of 2 append one duplicate and set the Qty to
1 (or zero), Qty of 3 append two duplicates and set the
Qty to 1 (or zero), etc...

Thanks,

Jim