Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Help

Status
Not open for further replies.

diktyo2001

Programmer
Joined
Dec 26, 2009
Messages
1
Location
GR
I have a simple table with fields NAME, ADDRESS and NUMBER. I want to produce an SQL result set and use it to print labels. The NUMBER field says how many labels to print for the current record.So when NUMBER is 0 no label is produced, when it is 3 , three labels are printed for this record etc. Instead of trying this at print time I thought it better to use SQL to produce for each original record in my table as many duplicate records as the NUMBER dictates.
I am afraid this exceeds my SQL skills.
Any help appreciated.

Thanks

Petros
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top