Append Multiple copies of each record

[Guest]

I have a table (tblBooks) like with the following fields

BookID, Quantity, Price

I want to append this to another table (tblCopies), my problem is that I
want to append each seperate copy of each book into its own record.

So for example tblBooks has the following record
11241, 5, £221

I would like to append 5 records to tblCopies with the following info:

11241, £221
11241, £221
11241, £221
11241, £221
11241, £221

Can anyone explain how I might do this?

 

[Duane Hookom]

Create a table of numbers with a single numeric field:
tblNumbers.Num
1
2
3
4
5
...
max quantity

Create an append query with tblBooks and tblNumbers. Don't create any join
lines. Set the criteria under the [Num] field to
<=[Quantity]