split field

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi, i need to update field 2 with the contents of field 1 minus the first 6
charaters, and i cant work out the syntax. Could someone help me please

thanks
A
 
Alex,

UPDATE MyTable
SET Field2 = Mid(Field1,7)
WHERE x = y

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top