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
 
You must log in or register to reply here.

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

Split data in field on character return 0
Splitting fields in access 2010 0
sum field name is single character 2
split up one field into multiple fields 2
Split address field 3
Update qry removing ONLY Alpha 4
removing unwanted characters 1
Pull first 3 characters out of the data field 1

Back
Top