B
Brian via AccessMonster.com
I am creating a report that will print labels for our product before it is
loaded on the delivery trucks. I created a query that contains all of the
information, and then used the "Label Wizard" to create the label. I have
two issues:
1) I'd like to print "1 of 3 Units" "2 of 3 Units" etc. I can get the "3"
part from the QtyOrdered field, but how can I create the first number? I'd
like to have 3 labels (one for each unit) printed.
If this is not possible, can I have the tag duplicated [QtyOrdered] number
of times? I can live with having just "3 Units" on each tag, as long as
three tags are printed.
2) I am storing the description of the item in our Inventory table as
memDescription - "memo" data type (design view of table). Is this why the
description is unavailable in the Label Wizard? Am I only allowed to use
strings?
Thanks for any assistance you can offer.
Brian
loaded on the delivery trucks. I created a query that contains all of the
information, and then used the "Label Wizard" to create the label. I have
two issues:
1) I'd like to print "1 of 3 Units" "2 of 3 Units" etc. I can get the "3"
part from the QtyOrdered field, but how can I create the first number? I'd
like to have 3 labels (one for each unit) printed.
If this is not possible, can I have the tag duplicated [QtyOrdered] number
of times? I can live with having just "3 Units" on each tag, as long as
three tags are printed.
2) I am storing the description of the item in our Inventory table as
memDescription - "memo" data type (design view of table). Is this why the
description is unavailable in the Label Wizard? Am I only allowed to use
strings?
Thanks for any assistance you can offer.
Brian