Remove first 10 characters

[Guest]

Hello,
I'd like to remove the first 10 characters of field1 and update an empty
field (field2) with the result.

Thanks for your help,
Ellen

 

[Ken Snell \(MVP\)]

Check out the Mid function.

 

[Guest]

Thanks. "Mid([Active Z Petitions]![field1],11)" in the "update to" part of
the update query worked.