Default value = previous value + 1?

[Chrisopia]

Is this possible? if so how would I apply that into access?

I only need this at table level, but if this isn't possible - i.e. through a query, what is the best way to do this and how??

 

[John Big Booty]

Check out the Dmax() function.

Try Dmax(FieldName,TableName)+1