Help creating multiple records

[coryt]

Hey folks.
Can someone help me with this scenario?

I have a table that has 1 record per person. There is a field called "Quantity" for each record. Is there a Query or something I can create that will take the value for "Quantity" and list 1 record for each.

ex. If the quantity is 5. I need to be able to create a table that has 5 records for that person.

THanks in advance.

 

[coryt]

Well. I will be using this table to produce labels. So if say Cory needs 5 labels. I need a table that has 5 records containing Corys information. If Betty needs 7 labels, there needs to be 7 records containing Bettys information. Right now I have a table with one record saying Cory gets 5 labels and one record saying betty gets 7 labels etc.