ghettocounselor
asked on
MS ACCESS - I have numbers stored as TX and so there's no leading '0' aka .9 is not 0.9
How do I format this as a number ?
.9 to 0.9 in the MS Access
.9 to 0.9 in the MS Access
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
unfortunately, the format function actually converts numeric values to a string, so, depending on where you want to use this, you might simply want to set the Format property of the control on the form or report where you are displaying the value.
Then apply the Format() function to the numeric value.
ASKER
In the end I'm concatenating a handful of things together from two different systems one with 0.9 and one with .9 to then compare the concatenated strings searching for missing items so I needed the number to match.
both the of the selected solutions do what they are intended to do, i ended up using the CDbl function because it only changed the .9 to 0.9 and not 1 to 1.0 like the Format function, which although not specified initially was something I needed.
Thanks for the help!
both the of the selected solutions do what they are intended to do, i ended up using the CDbl function because it only changed the .9 to 0.9 and not 1 to 1.0 like the Format function, which although not specified initially was something I needed.
Thanks for the help!