When i try this
Code:
query = "INSERT INTO Users(ClockNum, FirstName, MiddleInital, LastName, Dept, DeptLocation, Location, Phone, Supervisor, Email)" & _
"VALUES('" + Forms!Insert_User.ClockNum + "', '" + Forms!Insert_User.FirstName + "', '" + Forms!Insert_User.MiddleInitial "', " & _
"'+ Forms!Insert_User.LastName + "', '" +Forms!Insert_User.Dept+"', '" + Forms!Insert_User.DeptLocation +"', '"+Forms!Insert_User.Location+"', " & _
"' + Forms!Insert_User.Phone +"', '" +Forms!Insert_User.Supervisor+"', '"+Forms!Insert_User.Email+ "');"
I get a syntax error on this statement.