Insert character into string 1

[JoanieB]

I need to count back 5 places from the right of a string and insert a decimal point. I need to do this for an entire table - I know how to do the whole recordset thing and scroll through all the records, but how do I actually insert the character? "Help" was no help at all...

 

[jebry]

Hi!

Try this:

YourField = Left(YourField, Len(YourField) - 5) & "." & Right(YourField, 5)

You could use this in an update query as well and it will run a little faster.

hth Jeff Bridgham
bridgham@purdue.edu