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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top