Repeat Print

[cpecoraro]

Need to print one label repeatedly but changing the
pallet# info every so many labels. Example: there are 12
labels all with same information, but need to print all at
once with labels 1 thru 3 to say pallet#1, labels 4 thru 6
say pallet#2, & so forth. Pallets have to grouped and
increased by one every so many labels. Is there a way
this can be done based off of what is typed in the
report? Thank you....

 

[Duane Hookom]

Could you provide your table structure/fields and how pallet configuration
is stored in your data?

 

[Guest]

The user enters the information into a form based on 2
tables. Only need to enter once. Example: Pallet#, UPC,
date, etc. Would like a macro, pop up form, anything for
them to click on before they print that says how many
copies they need, but after so many the pallet number
needs to be increased by one. All will have same info
except the pallet number needs to be increased. The reason
being that 4 copies of each pallet# are needed. One goes
with paperwork, one on the pallet, etc. Right now we have
a CAMS program that all you do is enter the pallet number
such as 1, then how many repeat print times you want such
as 4, and after every four the pallet number goes to next
consecutive number, prints 4 tickets, then goes to next
pallet# & prints four times, & so forth. Is there a code
or anything I can do to make this happen. We are trying
to get this dept on Windows 2000, cannot with the CAMS
program without updating CAMS. This is difficult to even
explain. Any help would be appreciated.

 

[Duane Hookom]

It looks like you could use a table of numbers from 1 to whatever big
number.
tblNums
============
Num integer field with values 1 - 1000
It would really hope to know if any values were stored in a table. However
assuming you want 4 copies of every ticket, you can add tblNums to your
query without joins. Place a criteria under the Num field of <=4. This will
output 4 of every record. Consider using a similar solution for other
repeats/numbering that you need to do. You can add tblNums into your query
several times.

 

[Duane Hookom]

Consider your [Num] values 1 - 50. How would you use these to create pallet
numbers?
Try subtracting 1 from the Num to get 0-49.
Then integer divide by 4 ( (Num-1)\4 to get groups of 4 numbered from 0 to
12.
Then add 1 to this number.
PalletNum: (Num-1)\4 +1

You need to learn how to figure this out for yourself. Take a look at what
you have and ask yourself "How can I get from these values to my desired
outcome?"