Adding decimal (".") within a Field e.g "xxx" to "xx.x&

[avishek29]

Hello,

I am trying to add a decimal point within a field.

eg. Field 1 reads "12345"

I want to change it to read "123.45"
in microsoft access.

How would i do this?

Thanks for your help,
Avi

 

[PHV]

What have you tried so far ?
If field1 is numeric:
Format([field 1]/100,'0.00')

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886