diktyo2001
Programmer
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
I am afraid this exceeds my SQL skills.
Any help appreciated.
Thanks
Petros