Assign numbers from 1 thru 9 to a set of records
i've been looking at autonumber function all day and I haven't found one that does it, maybe I'm looking for the wrong thing? it's not autonumber but called something else?
EDIT: I have 9 ROWS, not fields
Thank you for taking the time to report an issue.
What's wrong... Please write below.
For example, for a Document Control Number I need it to only assign starting with 00-700-06957 and going up. It will be a one user only program. I know I have to do this with DMAX butcan't figure out how or where to put it.
How to assign sequential row numbers to each row in a query.
How to calculate a running total.
How to calculate or update "week of the month."
How to calculate student grades from test results.
How to determine the lowest five values of a record set, instead of the highest five values.
How to determine which customers purchased both products.
How to determine which tables are no longer needed as sources for queries or forms.
How to "Find and Replace" a value in as many records as needed.
How to read Jet's query execution plan to write more efficient queries.
How to use Jet SQL to append records to a table from a text file.
How to use Jet SQL to insert records into a remote database that has a database password.
How to use Jet SQL to update records in (or from) a remote database that has a database password.
How to use a user-defined VBA variable as criteria in a query.
Where to find SQL developer tools to practice with.
No. 1124 (ref A) contains 30 numbers (ref B) 01, 02, 03 ect up to 30 No. 1101: contains 60 numbers 01, 02, 03 up to 60 ect
No. 1411: contains 70 numbers 01, 02 up to 70
Ref B numbers can vary and need to be edited as and when needed.
I'm assuming that each second set of numbers (ref B) need to have individual unique identifiers , but how would I go about creating and mapping to (ref A) numbers?
1 – 99997000
2 – 97561332
3 – 97568123
4 – 94568711
5 – 12345677
1 – 97561302
2 – 97561295
Than repeat this process another 20 times unit all the 100 numbers have a random value from 1 to 5.
Table1 has am ID field (numbers) and Table2 records have those ID numbers and they are identical.
what I want to do is to update the Table2 records which have the same IDs as my Table1 records and update (i.e modify ! ) their content with the content of the corresponding Table1 record (which has the same ID)
hope I explained well.
does some one know how could it be done ?
What's the best way to do this? I was thinking of using a pop-up form but would like to hear of other methods.
I need to create a registeration database for a shooting sport competiton event that can either automatically assign each new registerant a target number when they are entered into the database, or allow me to enter different number if I wish.
Numbers of the group will appear and a textbox to write a beginning number to start with to assign a group of numbers to that group.
A button to start the procession and another button to re-open the for to continue assigning other groups.