Assign numbers from 1 thru 9 to a set of records

How do I do that? I have 9 fields that I need to be able to number everytime I run a function and they MUST not skip and they MUST start at 1

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

Sponsored Links:

Related Topics

Having Problems With DMAX
I'm trying to design a database where I need it to automatically assign specific numbers I want it to assign.

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.


Mapping to numbers
I have to design a database (and front-end app) that contain reference numbers that relate to various groups of additional numbers.

An example

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?


Queries how tos
How to assign "odd" or "even" value to every record in a table.
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.


Assign a random# (1-5) to a table of 100#'s
I’m working in access and I’m trying to assign a random value from 1 to 5 to a table of 100 numbers (that are 8 digits long). For instance,

1 – 99997000
2 – 97561332
3 – 97568123
4 – 94568711
5 – 12345677
1 – 97561302
2 – 97561295
Etc….

Than repeat this process another 20 times unit all the 100 numbers have a random value from 1 to 5.


A somehow sophisticated Update Query !
I have two tables which don't have any relationships and I can not set any for them because of some reasons.

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 ?


automatically assign numbers
I am very new to database building.

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.


Assign a Number to a Group of Records
I have a group of records in a Table that I need to assign a number to before appending them to another table.

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.


Updating the next n number of records
I really just can not figure this out and it seems like it should be so simple. I've got a list of records that are to be assigned to users for completion. I'm trying to make an update query that uses a (list? combo?)box from a form to select a user and a text box to input a number of records to assign to the user. So essentially I want the query to assign N incomplete records to X user, and I just can not for the life of me figure this out


How to assign work to multiple users?
I need to create a form that allows the user to enter the number of records they would like to work on and then assign those records to them. For example, have a form with open text box asking to enter the number of records to be assigned? The user enters any number (say 50) and the first 50 records in the queue are assigned to their current user ID.


Assigning numbers to certain fields
I need to automatically distribute numbers to certain group of fields according to the selection of the user. I.e. on opening the form, the user is asked to enter the first number of the group and then the last number of the group.

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.


Query not picking up fields with text and numbers.
I have 2 tables with a list of part numbers in each.

Table 1 (over 1.4m records) is my master parts number table with part number as a field and a standard cost as the other field.

Table 2 is a list of part numbers (only a couple thousand) that will change monthly. These part numbers are listed in table 1 and have standard cost values.

I'm trying to run a query to basically lookup the part number from Table 2 and return the standard cost value found in Table 1. This query is working great for part numbers containing only number (ex.

2074849). The query is not returning standard costs for parts containing numbers AND text (ex. 1A0621). Both Table 1 and Table 2 have primary keys set to the part number, and have a relationship setup between the part number. The data type on both tables is set to "Text".

How can I get the part numbers containing both numbers and letters/text to return my standard costs?


loop based on a given set of numbers
I have a set of numbers, say (1,3,5,6,8,11)

I need to use each of them one time in a sql where clause and print report seperately. I also need to use them as part of my exported file name.

How do I loop based on those numbers?


Assigning numbers to certain fields
s,
I need help with the attached form. I need to automatically distribute numbers to certain group of fields according to the selection of the user. i.e. on opening the form, the user is asked to enter the first number of the group and then the last number of the group. 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.


Error in importing .txt files
I've set up my vba to import some .txt files on the click of a button.
That's all fine, except, while importing I get the message:

Microsoft Access was not able to import all the data etc etc
The contents of fields in x records was deleted etc

When I look at these tables in excel, I can't see any reason why these particular records are causing a problem. They're all numbers, none are negative, they're not the longest numbers & as far as I can see there's no random spaces before or after them (certainly not when I open them in excel).
Has anyone else had the same problem? Are there any suggestions for how I can get around it? I need these numbers to be imported for the monthly calculations & outputs


Import from Excel
I am trying to import Excel worksheet into Access 2003 table. The problem I have is with fields that have mixed data types. It is trying to guess the data type based on the first group of records (depending on how it is set in the registry - in my case the default is 25).

For example in ZIP code column the first 25 records may be numeric so it will assign "Double" data typeto it, however records further down may be something like
10001-9999 and import of those values would fail.
I set TypeGuessRows in[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel] to 0 and it works - now it scans all records to determine the data type. However, each time I invokeimport data dialog in Access and select excel file, the default of 25 for TypeGuessRows returns and I have to change it again in the registry.
Is there a way to set it permanently to 0?


Can not show SubForms or Lists
I create a table that is created my a vba program that list unused numbers (formated as text) from another table.
What I am trying to do is get a list of the unused numbers so as to have an easier time of assigning those numbers to the main records.

When I pull up the form that is supposed to allow me to do this I get the list of records shown at times, at other times they are shown but after I start entering data they change to "#Deleted " or just come up with "#Deleted" being shown.

As these numbers are not already linked to any records, or the main records. what can be done to inable the form to show the unused numbers without having the fields go to "#Deleted"?


Import from Excel
I am trying to import Excel worksheet into Access 2003 table. The problem I have is with fields that have mixed data types. It is trying to guess the data type based on the first group of records (depending on how it is set in the registry - in my case the default is 25). For example in ZIP code column the first 25 records may be numeric so it will assign "Double" data type to it, however records further down may be something like

10001-9999 and import of those values would fail.

I set TypeGuessRows in[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel] to 0 and it works - now it scans all records to determine the data type. However, each time I invoke import data dialog in Access and select excel file, the default of 25 for TypeGuessRows returns and I have to change it again in the registry.

Is there a way to set it permanently to 0?


Enter data between range then split
We have a situation where we need to enter a range of pallet numbers into a form, but then have the table behind the form store the numbers in the range individually.

For example, the data entry may be Pallet Numbers 1 - 50. We would need it stored in the table as Pallet Number 1, Pallet Number 2, Pallet Number 3 and so on. This is so that we could then assign an action to each pallet - for instance, we may release one or two out of the range at one time, then the rest later, or we may dump certain pallet numbers.

I can't have the user always enter each pallet number individually as this would take too long, though in some instances there may only be one or two pallet numbers, in which case they would enter them individually.


Way to restore AutoNumber for ID?
I did something dumb -- I accidentally changed the ID field type in tblPeople from AutoNumber to Number. (Can't revert to a backup, either.)

I would like Access to automatically assign ID numbers as I add names to the table, so having ID as a Number field won't work. I also want to keep the ID numbers already assigned


Search box not working
I am using Access 2010 and have downloaded a standard contacts database but I have found that the standard search function at the bottom of the form is not allowing me to find mobile phone numbers in my records.

It allows me to search for the first 7 numbers and then stops. We have a large number of sequential mobile numbers allocated to people and the first 7 numbers are the same for a number of people however the last 3 numbers determine who has which phone.

I need it to search for 10 numbers.