
Originally Posted by
Lynette
Am delighted that it is possible to transfer text in quotation marks to a new field globally. Please could you give some indication how this is done - if not too time consuming. I could get an IT person to do it for me.

I'm inclined not to answer Lynette, because your lack of giving specifics is very frustrating. If you had:in a field "myfield", and you want to transfer it to the next field in the same table named "myfield2", you would write in a query:
Code:
update table mytable set
[myfield2] = mid([myfield], 2, len([myfield]) - 2)