trim leading 8 charactors in a Field with a query

  • Thread starter Thread starter GeoffK
  • Start date Start date
G

GeoffK

Hi All,

I have a field which has the following data "Value of $00.00", this is
consistant with only the $00.00 amount changing.

I would like to trim the "Value of $" from the field and leave only the 00.00.

Thanks in Advance

GeoffK
 
In query design view, try typing something like this into the Field row:
Mid([YourFieldNameHere],9)

If that gives the correct results, switch the query to an Update query
(Update on Query menu), and move the expression into the Update row under
your field.
 
Back
Top