One way is to have a special table in the database with any number of sequentially numbered rows from 1 to whatever, lets say 1000.
Create a view which does a Cartesian join of your address table with the Numbers table. CREATE VIEW ManyLabels AS SELECT colame1, colname2, .... + FROM Addresses, Numbers Notice there is no join clause. This view returns 1000 copies of every row in your address table. Create a label definition on that view. Then you can say LBLPRINT MultiLabels WHERE AddressID = .vAddressID AND NumberID between 1 and 30 -Dennis McGrath -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Johnson Sent: Wednesday, November 20, 2002 12:45 AM To: [EMAIL PROTECTED] Subject: RE: Labels To All: Nancy asks a great question. There are times I would like to print 30, 60, or an entire sheet of identical labels. Sounds deceptively simple. No problem projecting a dummy table but how do you populate it with 30 rows? Code to Add & Duplicate 30 times? Haven't looked at the documentation on this one yet, the thread caught my interest. Steve ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
