Declare @myVar int=0; update tbl_Project SET @myvar = project_Id = @myVar + 1
Dim i As Integer i = DMax("FieldName","TableName") +1
Null
SELECT Nz(MAX(FieldName),0) +1 As [MaxPlusOne] FROM TableName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)