Printing Labels

[gatetec]

I have a simple query for address label.

select fname, lname, addr, city, st, zip
from demo

I want to print three addresses per row so that I can save trees.


Jone Doe Sue Doe Jim Doe
1234 ABC Street 1233 DEF Street 1233 GHI Street
Good City, PA 21043 Fun City, PA 21042 Great City, PA 21041

Harry Doe Liz Doe Tim Doe
1234 ABC Street 1233 DEF Street 1233 GHI Street
Good City, PA 21043 Fun City, PA 21042 Great City, PA 21041

bla.....

How do you format this?

thx

 

[philhege]

Use a variation of the technique that's explained in this FAQ.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.