I've never tried this, but I think you could do it with a view. Create a temporary table with 30 (or however many) rows. I'm not sure that you would even need data in it. Then create a view against it and your current table.
Create temp Table DummyTempTable DummyText Text 4 Insert into DummyTempTable (DummyText) + sel 'X' from sys_Tables whe limit = 30 Create Temp view ViewName (Your column list) as + Sel -columns from your mailList table here- + From YourMailListTable t1, DummyTempTable t2 Base your labels on the view. You see there is no where clause to correlate the two tables. This is normally a bad thing, as the rows in T1 will be duplicated by the number of rows in T2. I've never done this (on purpose <g>) so you might need to work with it a bit. Ben Petersen On 20 Nov 2002, at 1:45, Steve Johnson wrote: > 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/
