Append (multiple rows) Query

[Ste4en]

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

 

[KenHigg]

Build an ADO routine.

Ken

 

[chris davies]

make the criteria of the query for quantity >=1