Need to add decimal to field for displaying

N

Nancy

Hello -

I have a database field containing the value of 2330. I need to display
this as 23.30. The field is display only, I do not want to store this as a
decimal in the database.

I have tried the following:
* Creating a unbound field, with the control source pointing to this field.
The format is currence and I have two decimal places. I get $2330.00, not
quite what I want.
* I did a manual select based upon another field and divided the number
/100. Nothing happened.

Is there anything else I should be trying?
 
Top