S Salvio F. Arguelles Jan 27, 2004 #1 I need a function that could automatically add numbers in the table by 1 with a resetting function
N Naresh Nichani MVP Jan 27, 2004 #2 Hi: Try using the DLookup function dlookup("Max([ID])+1","[tbl1]","") This assumes you want to get the max of the [ID] field of table [tbl1] and add 1 to it in a function. Regards, Naresh Nichani Microsoft Access MVP
Hi: Try using the DLookup function dlookup("Max([ID])+1","[tbl1]","") This assumes you want to get the max of the [ID] field of table [tbl1] and add 1 to it in a function. Regards, Naresh Nichani Microsoft Access MVP
