importing values into existing records

[tnasch]

My target is to allocate specific numbers to my 963 existing records. The number needs to increase by 1 every 5 records. So records 1 - 5 are all allocated number 1, 6-10 2, 10-15 : 3 and so on.

I have created a new field for this new number to be displayed in but I can't work out how to auto-enter the data I require.

Any help would be gratefully received - thanks!

[comment]

If this is a one-time operation:

Show all records, in the order you want them numbered. Click in the new field and select Records > Replace Field Contents… > Replace with calculated result:

Ceiling ( Get (RecordNumber) / 5 )

Alternatively, set the field to auto-enter a serial number and use a calculation field for the grouping (this will work for any new records, too).

[tnasch]

brilliant! thank you very much.

[tnasch]

Actually, now I need to perform a similar task but with a different found set. the number needs to repeat every 3 records but I need to start the number from 194 instead of 1.

I've tried changing the calculation function but am not having much luck. Can you (or anyone) help me a little further.

Thanks.

[comment]

How about:

Ceiling ( Get (RecordNumber) / 3 ) + 193