W
wvrider
I have a table that has field name of Total_Tax with a data type of currency.
The data in the field can range from being blank to 999999999.99. Maximum is
9 numbers before the decimal place and 2 afterward.
My problem is that the data was imported from a text file into access as
400. However that should be formatted to 4.00 or 1234 should be 12.34.
Also a number that is 123456789 should be 1234567.89.
I further want to format it to currency for easier reading and manipulation.
So I would like to insert $ signs and delimit them with a comma. So I need
to go from 12345678 to $123,456.78, as 1234 should be $12.34
I was thinking maybe this: Format([TextField], "0.00"), or something like it
but not sure if it will work.
Any suggestions on how I can do this? I greatly appreciate it.
The data in the field can range from being blank to 999999999.99. Maximum is
9 numbers before the decimal place and 2 afterward.
My problem is that the data was imported from a text file into access as
400. However that should be formatted to 4.00 or 1234 should be 12.34.
Also a number that is 123456789 should be 1234567.89.
I further want to format it to currency for easier reading and manipulation.
So I would like to insert $ signs and delimit them with a comma. So I need
to go from 12345678 to $123,456.78, as 1234 should be $12.34
I was thinking maybe this: Format([TextField], "0.00"), or something like it
but not sure if it will work.
Any suggestions on how I can do this? I greatly appreciate it.