Serial number generator II

[Guest]

Thank for the reply John:

No more than 5 numbers. numbers need to be printed on small white sticky
tags to be placed on product.
no information on them, just last number used.
Thanks

 

[John Vinson]

Thank for the reply John:

No more than 5 numbers. numbers need to be printed on small white sticky
tags to be placed on product.
no information on them, just last number used.
Thanks

Given that, I'd suggest not storing one record per serial number.

Instead, use a Form (frmMyForm) with two textboxes, txtStart and
txtEnd; and a handy general-purpose table called Num with only one
field, a Long Integer number field N as its primary key. Fill Num with
numbers from 0 to the most numbers you'll ever need at once (be
generous - 100000 rows is still a very small table).

Create a Query

SELECT N+[Forms]![frmMyForm]![txtStart]
FROM Num
WHERE N+[Forms]![frmMyForm]![txtStart] <= [Forms]![frmMyForm]![txtEnd]

and base your label report on this query.

John W. Vinson[MVP]