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.
 
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

Updating Groups of Records via a Form 1
Leading Zero Dropped in Text Cell 3
Crosstab query with multiple fields 2
Help with Query 3
correlate a series of numbers in mm:ss to another column also in m 1
Decimal places problem 1
MS Access - Format in Export 3
Help...Want to make integer down to hundreth in qry. 2

Back
Top