NEED TO MAKE DUPLICATES IN TABLE. NEED HELP

[hrg]

I have a database. Within this data i have a problem. When i want to print out the number of products for each customer it only prints one address label. What i need is to be able to write "3 of the same product for one customer" but they have to go out as three separate posts (due to costs) so the database needs to print out the customer details 3 times. I would like the database to either :-

1st, if i enter customer detials and they want 3 coke cans and the user enters 3 in the number of cans field. How would i duplicate the name address postcode etc. so that it copies the details three times to duplicate them.

Form

Name ____john___

Address ______may fair____

Post Code __my7 7fr____

Number of cans ____3__

etc


Table (Presently shows)

Name Address Post Code Number of cans

John May Fair my7 7fr 3


Table (needs to show)

Name Address Post Code Number of cans

John May Fair my7 7fr 3
John May Fair my7 7fr
John May Fair my7 7fr


How can i do this?

Can any one help thanks.

 

[DJN]

Have a look at this web site and look under Multiple Labels. There is a mdb which might be of some help.

http://www.rogersaccesslibrary.com/TableOfContents.asp