D
Dirtbike
I need to convert the following: Table with PartNum, Qty, and a True/False
field that will deturmine if the Qty of Partnum is to be repeated or not.
So, If the True/False field is true then Partnum and Qty are carried to a new
table as is. If the True/False field is false then the Qty of Partnum needs
to be converted. For example if False, and Qty is 3 then create (3) records
in a new table for (1) each. If True then create (1) record for (3) each.
Don't worry about the testing of true/false logic. I'm stuck writing
something that will loop the required times resulting in the creation of
records.
Thanks for all the help here.
Scott in Charlotte, NC
field that will deturmine if the Qty of Partnum is to be repeated or not.
So, If the True/False field is true then Partnum and Qty are carried to a new
table as is. If the True/False field is false then the Qty of Partnum needs
to be converted. For example if False, and Qty is 3 then create (3) records
in a new table for (1) each. If True then create (1) record for (3) each.
Don't worry about the testing of true/false logic. I'm stuck writing
something that will loop the required times resulting in the creation of
records.
Thanks for all the help here.
Scott in Charlotte, NC