Formatting a number in a table to include 2 decimal places 1

[Guest_imported]

Hi,
Here is my problem. I have to get the data in a number
column to look this:
OLD NEW
6500-------->65.00
72146------->721.46
Any sugesstions as to how I can do the w/ Access SQL?
Thanks,
scotta

 

[JoeMiller]

Try this out Scott:
[tt]
NewNumber = Left(OldNumber, (Len(OldNumber) - 2)) & "." & Right(OldNumber, 2)
[/tt]

HTH Joe Miller
joe.miller@flotech.net