I have an append query which takes rows from one table and places them in another when a certain criteria is met. When the source table has a qty greater than 1; I need the receiving table to get a record for each qty e.g.

Source table:
partNumber; qty
123; 3
111; 1
121; 2

Receiving table:
partnumber; qty

123; 1
123; 1
123; 1
111; 1
121; 1
121; 1

How can I achieve this

thanks

Steve

Build an ADO routine.

Ken

make the criteria of the query for quantity >=1