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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Case When statement in Access Frontend with Sql Backend 6
Shift several columns in table 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Making four queries into one 1
Syntax error in query expression 2
Update or Append Query in Access 2003 2
query parameters 2

Top