incrementing sequence number with a given range

[robin121600]

I have a program in monitoring tag number but my problem is when a batch of
100 pcs tag arrived I encoded it one by one, 1 tag number has 10 digits so
its very stressful when I encoded all of them, could you please help me with
a code which is when I encoded in a form let say TagNumber from 1000000000
in txtbox1 and TagNumber to1000000100 in textbox2 it could automatically
encode in my tblTag (field is TagNumber) the 1000000000, 1000000001,
1000000002, 1000000003, 1000000004 and so on until it reach 1000000100.

The tag number is sometimes start with 2 zeros and sometimes starts with 1
zero.

Thank you

 

[KARL DEWEY]

Create a table named CountNumber with field CountNUM containing number from 0
(zero) through your maximum quanity.

INSERT INTO TblTag ( TagNumber )
SELECT [Enter Starting TagNumber]+[CountNUM] AS Expr1
FROM CountNumber
WHERE (((CountNumber.CountNUM)<=[Enter qunaity of tags]-1));

 

[robin121600 via AccessMonster.com]

Thank you very much.

I got it.

Create a table named CountNumber with field CountNUM containing number from 0
(zero) through your maximum quanity.

INSERT INTO TblTag ( TagNumber )
SELECT [Enter Starting TagNumber]+[CountNUM] AS Expr1
FROM CountNumber
WHERE (((CountNumber.CountNUM)<=[Enter qunaity of tags]-1));

I have a program in monitoring tag number but my problem is when a batch of
100 pcs tag arrived I encoded it one by one, 1 tag number has 10 digits so

[quoted text clipped - 8 lines]

Thank you