Product Labels - "1 of 3 Units" ?????

  • Thread starter Thread starter Brian via AccessMonster.com
  • Start date Start date
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
 
You can create a table of numbers "tblNums" with a single numeric field
"Num" with values 1 through your max quantity. Add this table to your
report's record source query and don't join it. Add the Num field to the
grid and set the criteria under it to
<=QtyOrdered
When you run the query, you will see numbered records for each item ordered.

You can always add fields/text boxes to the labels after the wizard has done
its thing.
 
Thank you very much!

About my 2)... I know you can convert it to a string after it is in the
query, IE:

|memDescription |strDescription: CStr([memDescription]) |
|----------------|-----------------------------------------|
|tblInventory |tblInventory |
|----------------|-----------------------------------------|

But when I click Run, I get an error saying there are to many ")" in the
formula strDescription: tblInventory.[CStr([memDescription])].
 
Sorry about that, they all lined up when I was typing them... I realize
though, that I don't need tblInventory in the bottom, and I just made my
expression look like this: "strDescription: CStr([tblInventory]!
[memDescription])" with nothing in the Table row.

Thanks a lot!
 
Back
Top