Enter a dot between numbers

[Dimitris]

Hello,
In a text field there are numbers entered. I want a dot entered before the
last two digits. So the number 64521 will become 645.21
I don't just need to view this format but to permantly change the numbers in
this form.

Thank you in advance
Dimitris

 

[John Spencer]

STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the way you
expect.

UPDATE [YourTable]
SET [YourField] = Left([YourFIeld],Len([YourField])-2) & "." &
Right([YourField],2)
WHERE IsNumeric([YourField]) = True and Len([YourField])>1

Possible bad results - which should be taken care of by the criteria:
-- Field does not contain number characters
-- Field has only 1 number character

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County