Assigning Value to a Range of Numbers

[jrs]

Hello All. I don't use Access as much as the other office products but I'm
creating a database table. We have a pad of invoices (25 in a pad). When I
give a pad to a user, I would like to be able to create a table that says 500
- 525 assigned to User 1. So in that table, I would like to have 25 records
(i.e. 500, 501, 502, etc) and in field 2 - "User 1" is displayed all the way
down to 525. I would like to have a form where the user enters 526 - then
"user 2" and the table populates with 25 more records from 526, 527 and so on
with User 2 in the second field. Can this be done? Thanks in advance.

 

[KARL DEWEY]

Create table named CountNumber with field CountNUM containing numbers from 0
(zero) through say 100.
Substitute your table and field names in query below --
INSERT INTO YourTable ( INVOICE, USER )
SELECT [Enter starting number] + [CountNUM] AS INVOICE, [Enter user] AS USER
FROM CountNumber
WHERE CountNUM < [Enter quanity of invoices] + [Enter starting number];