Topics Search

Assign numbers from 1 thru 9 to a set of records

Assign numbers from 1 thru 9 to a set of records
Views: 21
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:

Similar posts...


Having Problems With DMAX

Having Problems With DMAX Icon
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

Mapping to numbers Icon
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?

A somehow sophisticated Update Query !

A somehow sophisticated Update Query ! Icon
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 ?

Assign a random# (1-5) to a table of 100#'s

Assign a random# (1-5) to a table of 100#'s Icon
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

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

Updating the next n number of records

Updating the next n number of records Icon
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

Assign a Number to a Group of Records

Assign a Number to a Group of Records Icon
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.

How to assign work to multiple users?

How to assign work to multiple users? Icon
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.

automatically assign numbers

automatically assign numbers Icon
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.

Can not show SubForms or Lists

Can not show SubForms or Lists Icon
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"?

Error in importing .txt files

Error in importing .txt files Icon
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