I want to get the last value in a field and add 1 to it in a form

N

need help

i want to get the last value entered in a field and add 1 to it when i enter
a new data.

i did put =Max([filed name])+1 but only come up with 1
 
F

fredg

i want to get the last value entered in a field and add 1 to it when i enter
a new data.

i did put =Max([filed name])+1 but only come up with 1
Click to expand...

If the last value is always the maximum value then:

=Nz(DMax("[FieldName]","tableName"))+ 1
 
Top