query

C

convert

(UPDATE 'TABLENAME' SET FIELD1 = substring (field2,2,1)

I vant to convert abave query to access query
 
J

John Spencer MVP

UPDATE [TableName]
SET Field1 = Mid(Field2,2,1)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Top