Autonumber in MSAccess

[finbarrodonovan]

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

[RobDog888]

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.

SELECT MAX(AutoID) As CurrentID FROM Table;

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

[wrack]

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

[RobDog888]

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

[wrack]

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

oops...Nevew noticed that one.