Auto-incrementing without using Autonumber... 1

[nettproffen]

Hi.

I`m a newbie to this.

I already have one autonumber coloumn in my table, but I also need a second integer coloumn in the same table, that auto-inserts numbers, starting with 1, then 2 and 3 and 4 and so on for every record that is inserted. No duplicates.

Is this possible, and how?

Thanx very much in advance.

Bjørn.

 

[ZmrAbdulla]

Use DMax()+1
There are a lot of threads in this subject here. pls have a search.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.

 

[fneily]

Here's the standard autonumber answers:

Let’s say you want the numbering to begin with a different number other then 1. Let’s say 57. Create your table with NO data and no primary key. Have a field called ID and make the data type Number. Save your table. Select your table, right click and select Copy. Then right click and select Paste. Give it a new table name and select Structure Only. Open up this new table and create one record with ID the starting number one less then the one you want, in this case 56. Close this table. Open the first table and now make the ID field an Autonumber type. Close the table. Create an append query from the second table appending the one record to the first table. Now open the first table and add another record. It will automatically be 57. Delete record number 56.

Let’s say you want to create your own autonumber field. Create a table with a field called ID. Create a form for that table. On the form, go to design view and click on the text box of the ID field, and open the properties sheet. Click on Default value and enter:
=Dmax(“[ID]”,”tablename”)+1
Now when you go to the next new record, it will be incremented by 1.

Let’s say you want an autonumbered field by Microsoft but want some characters in front of the number like mc001, mc002, etc. Go to design view, click on the autonumber field and in the Format box type “mc”00
This places mc next to 2 zeros and then tacks on the autonumber.

 

[nettproffen]

Hi.

Thanx for your reply.
It is working now. Thank you all.

Bjørn.