Autonumber in MSAccess

Does anyone know how through a sql statement to get the next number from a autonumber field in MSAccess.

I have two statements, (1st)one that inserts data into the autonumber table and (2nd) another statement that fills data in another table. The second statement must run before the first and i need the value of the autonumber for the second statement.

Any help would be grateful

Sounds like the db may need re-designing, but to accomplish what
you want you will need to make a primary call to retrieve the
current Autonumber value for the second statement.

Code:

---

SELECT MAX(AutoID) As CurrentID FROM Table;

---

Then pass the value to the second statement and then run the
first statement.

You might need to add 1 to what u get since you asked for next number in autonumber field.

That is right, but that is why I aliased the field as CurrentID.

Quote:

---

Originally posted by RobDog888
That is right, but that is why I aliased the field as CurrentID.

---

oops...Nevew noticed that one.:)