ethanjohnsons
asked on
Printing Labels
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx much