Insert decimal?

[Andy Jenkins]

I'm thinking this ought to be easy (just not for me - lol).

Field Price has values like this:

12500
9999
12999
105099

What's happened is that the person who originally populated it neglected to
put in the decimal point. So I need to start from the right, move 2 digits
to the left and drop a decimal in to get:

125.00
99.99
129.99
1050.99

Mid function? Not sure...

Thanks.

[fredg]

On Fri, 24 Mar 2006 13:16:25 -0600, Andy Jenkins wrote:

I'm thinking this ought to be easy (just not for me - lol).

Field Price has values like this:

12500
9999
12999
105099

What's happened is that the person who originally populated it neglected to
put in the decimal point. So I need to start from the right, move 2 digits
to the left and drop a decimal in to get:

125.00
99.99
129.99
1050.99

Mid function? Not sure...

Thanks.

It depends.
What is the field's Datatype.
If it is Number Integer or Long integer, you cannot have a decimal
value.
If the datatype is Number (Double) or Currency,
=[FieldName]/100

125 becomes 1.25
12500 becomes 125

The above are still numbers.

If you just wish to display the value with 2 decimals, use:
=Format([FieldName]/100,"#.00")
but this is now a string value and cannot be used in future
calculations.
125 becomes 1.25
12500 becomes 125.00

You can use the above expressions in an Update query to permanently
change the field values.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail