D
dfinch
Guest
I'm VERY new to VB. I'm trying to do an Access query that compares the data of two fields and duplicates the record until the condition changes. The condition is this....if a customer orders 1000 parts and you can only put 300 on a pallet, I want the that record to repeat itself 4 times.....each time the order qty changes......300, 300, 300, 100 to total 1000. A simple statement I'm sure but difficult for me.
