label printing problem

[janvds]

I have a table with a few fields (ID, name, description, ...., stock)
I need a query with the amount of lines from the stock field.

So if stock = 5 for the first item, I would like to have 5 rows of tha
item. If stock = 2 for the second record, I need 2 rows for that one
If stock <1, that record should not show in the list

Anyone knows how to solve this

 

[Duane Hookom]

I would create a simple table of numbers [tblNums] with a single numeric
field [Num]. Add values from 1 through your maximum stock value.

Add this table to your query and set the criteria under the Num field to
<=[StockField]

 

[Allen Browne]

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to get Access to give you a row for each label,
using a Cartesian Product.