Lables Lables Lables

  • Thread starter Thread starter Shiner452
  • Start date Start date
S

Shiner452

I have a greenhouse company and I am trying to print lables for m
trays. I have used the lable wizard and it has been very helpful.
There is one problem though. Each crop has a different number of tray
and needs a certain number of lables. Is there anyway I can specif
criteria on a query to list a record a certain number of times in orde
to print that many lables. Can anyone help me here? Thanks
 
Does your table contain the number of labels required? It might help if you
provided us with the names of significant tables/fields so we could see what
you are working with.
 
"Does your table contain the number of labels required?"

Yes it does...My table has fields for 'Stock Number' 'Type of Plant
'Pot Week' 'Ready Week' and 'Number of Trays'...the 'Number of Trays
field specifies how many lables for each record need to be printed.
Those are not the actual field names just descriptions so you can ge
an idea of what i'm trying to do. Thanks for your help
 
"Does your table contain the number of labels required?"

Yes it does...My table has fields for 'Stock Number' 'Type of Plant'
'Pot Week' 'Ready Week' and 'Number of Trays'...the 'Number of Trays'
field specifies how many lables for each record need to be printed.
Those are not the actual field names just descriptions so you can get
an idea of what i'm trying to do. Thanks for your help.
 
"Does your table contain the number of labels required?"

Yes it does...My table has fields for 'Stock Number' 'Type of Plant
'Pot Week' 'Ready Week' and 'Number of Trays'...the 'Number of Trays
field specifies how many lables for each record need to be printed.
Those are not the actual field names just descriptions so you can ge
an idea of what i'm trying to do. Thanks for your help
 
"Does your table contain the number of labels required?"

Yes it does...My table has fields for 'Stock Number' 'Type of Plant
'Pot Week' 'Ready Week' and 'Number of Trays'...the 'Number of Trays
field specifies how many lables for each record need to be printed.
Those are not the actual field names just descriptions so you can ge
an idea of what i'm trying to do. Thanks for your help
 
I would prefer actual field and table names. However you could create a
table of numbers "tblNums" with a single numeric field "Num" with values 1 -
the maximum number of trays. Create a query with your table and tblNums and
add the Num field to the grid. Don't create any join lines. Set a criteria
under the Num column of
<=[Number Of Trays real field name]
This will result in a number of copies of each record equivalent to the
number in the field.
 
Back
Top