Enter multiple similar entries ACCESS (20 box serial numbers)

[Guest]

We create labels for every box produced in a day.
It may be 20 boxes of similar item.
Can I get 20 entries listed in my table so they can each have a unique item #?

 

[Marshall Barton]

Resinoid accountant <Resinoid

We create labels for every box produced in a day.
It may be 20 boxes of similar item.
Can I get 20 entries listed in my table so they can each have a unique item #?

Without a good reason, you shouldn't put that info in a
table. A fairly common approach is to create a separate
table (name it NumCopies) with one field (named Num) and
populated with records containing 1, 2, 3, ... up to some
number greater than the maximum number of items you will
ever have to deal with.

With this kind of arrangement, you can create a query for
the report:

SELECT yourtable.*, NumCopies.Num
FROM yourtable, NumCopies
WHERE num <= [Enter number of copies to print]