Enter multiple similar entries ACCESS (20 box serial numbers)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 #?
 
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 #?
Click to expand...


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