If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Assigning Value to a Range of Numbers
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. |
#2
|
|||
|
|||
Assigning Value to a Range of Numbers
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]; -- Build a little, test a little. "jrs" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|