Good afternoon. I am hoping some one can help, as I am at a complete loss. I have tried searching for this, but its not the easiest term to look up as it pulls results about counting combo boxes etc. I have being trying queries and count loops but with no success.
I am trying to create labels which show box x of y on the label plus the individual box quantity. I have the information below, which should generate 5 records.
From the data above(from a form) I was looking to return the data below, which I will link to my label templates.
Any help would be greatly appreciated.
Regards
Poco
I am trying to create labels which show box x of y on the label plus the individual box quantity. I have the information below, which should generate 5 records.
BoxQty | TotalQty |
20 | 85 |
From the data above(from a form) I was looking to return the data below, which I will link to my label templates.
Qty | X of | of Y |
20 | 1 | 5 |
20 | 2 | 5 |
20 | 3 | 5 |
20 | 4 | 5 |
5 | 5 | 5 |
Any help would be greatly appreciated.
Regards
Poco