In Access 2010 I have a db table with a field that has only numbers imported into it. The datatype is "NUMBER". I have been struggling trying to format as below:
NUMBER 4562359 format to 45623.59 The right 2 numbers always the cents.
NUMBER 4562300 would be 45623.00
I tried to do this in Access by formatting in design mode and also tried with an SQL statement. My SQL has to bring up 9 fields but this one field has to have this formatting. If I multiply every item in that field by .01 I get the right result but the problem lies in that I need to bring up 9 fields with that one having .01 applied and still have the same field name for that column.
Stuck!!
Thank You
Tom
tnfaxpay
NUMBER 4562359 format to 45623.59 The right 2 numbers always the cents.
NUMBER 4562300 would be 45623.00
I tried to do this in Access by formatting in design mode and also tried with an SQL statement. My SQL has to bring up 9 fields but this one field has to have this formatting. If I multiply every item in that field by .01 I get the right result but the problem lies in that I need to bring up 9 fields with that one having .01 applied and still have the same field name for that column.
Stuck!!
Thank You
Tom
tnfaxpay