G Guest Jun 29, 2006 #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
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 Jun 29, 2006 #2 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
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