C convert Jun 2, 2009 #1 (UPDATE 'TABLENAME' SET FIELD1 = substring (field2,2,1) I vant to convert abave query to access query
(UPDATE 'TABLENAME' SET FIELD1 = substring (field2,2,1) I vant to convert abave query to access query
J John Spencer MVP Jun 2, 2009 #2 UPDATE [TableName] SET Field1 = Mid(Field2,2,1) John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County
UPDATE [TableName] SET Field1 = Mid(Field2,2,1) John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County
