Printing Multiple Labels based upon the amount in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that shows information about individual product items and
includes a column for quantity on hand for each item. Each item has a
different quantity on hand. for example:
name QOH
item1 3
item2 2
item3 4
I would like to print labels, one for each of the items. In the above
scenario, I would need 9 labels and would like the labels for each item to
print consecutively. How do I format a report to read the "quantity on
hand" column and generate the appropriate number of labels for each specific
item?

Or, alternatively, how do I modify the query to show one line for each item.
For example, the query would show three repetitive lines for an item? For
example, if item1 has 3 in stock, the query would show:

item1
item1
item1

Thanks for any help.

Mary
 
You can create a table (tblNums) with a single, numeric field (Num) and add
numbers/records from 1 to your maximum QOH. Then add this table to your
report's record source query. Set the criteria under the Num field to:
<=[QOH]
 
If you need more details to follow the solution Duane suggested, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Duane Hookom said:
You can create a table (tblNums) with a single, numeric field (Num) and
add numbers/records from 1 to your maximum QOH. Then add this table to
your report's record source query. Set the criteria under the Num field
to:
<=[QOH]

--
Duane Hookom
MS Access MVP


MarySC said:
I have a query that shows information about individual product items and
includes a column for quantity on hand for each item. Each item has a
different quantity on hand. for example:
name QOH
item1 3
item2 2
item3 4
I would like to print labels, one for each of the items. In the above
scenario, I would need 9 labels and would like the labels for each item
to
print consecutively. How do I format a report to read the "quantity
on
hand" column and generate the appropriate number of labels for each
specific
item?

Or, alternatively, how do I modify the query to show one line for each
item.
For example, the query would show three repetitive lines for an item?
For
example, if item1 has 3 in stock, the query would show:

item1
item1
item1

Thanks for any help.

Mary
Click to expand...
Click to expand...
 
Thanks Allen, you were also a big help. I appreciate it. I'm checking out
your site right now. Mary

Allen Browne said:
If you need more details to follow the solution Duane suggested, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Duane Hookom said:
You can create a table (tblNums) with a single, numeric field (Num) and
add numbers/records from 1 to your maximum QOH. Then add this table to
your report's record source query. Set the criteria under the Num field
to:
<=[QOH]

--
Duane Hookom
MS Access MVP


MarySC said:
I have a query that shows information about individual product items and
includes a column for quantity on hand for each item. Each item has a
different quantity on hand. for example:
name QOH
item1 3
item2 2
item3 4
I would like to print labels, one for each of the items. In the above
scenario, I would need 9 labels and would like the labels for each item
to
print consecutively. How do I format a report to read the "quantity
on
hand" column and generate the appropriate number of labels for each
specific
item?

Or, alternatively, how do I modify the query to show one line for each
item.
For example, the query would show three repetitive lines for an item?
For
example, if item1 has 3 in stock, the query would show:

item1
item1
item1

Thanks for any help.

Mary
Click to expand...
Click to expand...
Click to expand...
 
Thanks, Duane. This is exactly what I needed. Super Simple, I just didn't
know how to do it. You're awesome! Thanks again. Mary

Duane Hookom said:
You can create a table (tblNums) with a single, numeric field (Num) and add
numbers/records from 1 to your maximum QOH. Then add this table to your
report's record source query. Set the criteria under the Num field to:
<=[QOH]

--
Duane Hookom
MS Access MVP


MarySC said:
I have a query that shows information about individual product items and
includes a column for quantity on hand for each item. Each item has a
different quantity on hand. for example:
name QOH
item1 3
item2 2
item3 4
I would like to print labels, one for each of the items. In the above
scenario, I would need 9 labels and would like the labels for each item to
print consecutively. How do I format a report to read the "quantity on
hand" column and generate the appropriate number of labels for each
specific
item?

Or, alternatively, how do I modify the query to show one line for each
item.
For example, the query would show three repetitive lines for an item? For
example, if item1 has 3 in stock, the query would show:

item1
item1
item1

Thanks for any help.

Mary
Click to expand...
Click to expand...
 
Back
Top