Tip Changing Numbers to Strings(Text) (1 Viewer)

[GohDiamond]

This is primarily for my own benefit so I won't lose the knowledge.

To convert a number to a string in MS Access SQL:

NumbertoText: Cstr([Your Numeric Field])

If the Number is masked(Formatted) and you want to preseve the format
Take for example a % between 0% and 100%
Convert Percentage to a String(Text)
NumbertoText: CStr(Format([% Numeric Field],"#" & "%")) for no decimal % or CStr(Format([% Numeric Field],"Percent")) for standard 2 decimal %

CStr(Format(1,"#" & "%")) = 100%
CStr(Format(1,"Percent")) = 100.00%


If this helps anyone, yw
Cheers!
Goh