Assigning a Field a number based on it's record position?

C

cpme

I am just learning Access so excuse me if this is a predictable question. I
am trying to assign a numeric value to the a field based on a record's
position in the table. For example: I want records 1 through 4 to to be
assigned the number 1 in the Field "Seed." Records 5 through 8 will receive
the number 2 in the Field "Seed" and so on and so forth for every four
records. This of course could be done manually but would be very tedious due
to the amount of records. It seems as though a simple IF/THEN statement
would due the trick but I've tried it every way possible. Can anyone help me?
 
J

John Vinson

I am just learning Access so excuse me if this is a predictable question. I
am trying to assign a numeric value to the a field based on a record's
position in the table.
Click to expand...

This will be more than a bit difficult, since records DO NOT HAVE
"positions in the table".

A table HAS NO ORDER. It's an unordered "heap" of data. New records
will be stored wherever Access happens to find room. Your basic
premise is therefore incorrect.
For example: I want records 1 through 4 to to be
assigned the number 1 in the Field "Seed." Records 5 through 8 will receive
the number 2 in the Field "Seed" and so on and so forth for every four
records. This of course could be done manually but would be very tedious due
to the amount of records. It seems as though a simple IF/THEN statement
would due the trick but I've tried it every way possible. Can anyone help me?
Click to expand...

This can certainly be automated, using a Form, but I must ask - why?
What are the other fields in this table? How will this [Seed] field be
used? What is the Primary Key of this table, and what other tables is
it related to?

John W. Vinson[MVP]
 
Top