label printing problem

  • Thread starter Thread starter janvds
  • Start date Start date
J

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
 
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]
 
Back
Top