G Guest Sep 19, 2007 #1 then I'm trying to calculate the maximum value for a field and add 1 to it and display this in a field on a form, when it is opened.
then I'm trying to calculate the maximum value for a field and add 1 to it and display this in a field on a form, when it is opened.
J John W. Vinson Sep 20, 2007 #2 then I'm trying to calculate the maximum value for a field and add 1 to it and display this in a field on a form, when it is opened. Click to expand... =NZ(DMax("[fieldname]", "[tablename]")) + 1 John W. Vinson [MVP]
then I'm trying to calculate the maximum value for a field and add 1 to it and display this in a field on a form, when it is opened. Click to expand... =NZ(DMax("[fieldname]", "[tablename]")) + 1 John W. Vinson [MVP]
G Guest Sep 20, 2007 #3 Thanks a bunch John. Works great John W. Vinson said: then I'm trying to calculate the maximum value for a field and add 1 to it and display this in a field on a form, when it is opened. Click to expand... =NZ(DMax("[fieldname]", "[tablename]")) + 1 John W. Vinson [MVP] Click to expand...
Thanks a bunch John. Works great John W. Vinson said: then I'm trying to calculate the maximum value for a field and add 1 to it and display this in a field on a form, when it is opened. Click to expand... =NZ(DMax("[fieldname]", "[tablename]")) + 1 John W. Vinson [MVP] Click to expand...
