B
BWolf
Hi all,
I have some code that I am trying to modify that I did not write. It
was written by someone who does not work for the company any more, and
I cannot figure out this one thing or find it documented anywhere.
Here is the code.
strLineNo = Format(txtLineSizeDia.Value, "##0")
If txtLineSizeFraction.Value <> " / " Then
strLineNo = strLineNo & " " & Format(txtLineSizeFraction.Value,
"0/0")
End If
strLineNo = strLineNo & "~"
Lets say txtLineSizeDia.Value = 8 and txtLineSizeFraction.Value = 1/2.
The final value for strLineNo = "8 1/2~". Now I follow the code up to
this point. But then after this there is a simple INSERT command into
a table. Now instead of "8 1/2~" getting inserted into the table,
"8.5" takes its place.
Am i missing something here. Can "~" be used in SQL to change mixed
fractions to decimals?? Please help.
Thanks
Brad
I have some code that I am trying to modify that I did not write. It
was written by someone who does not work for the company any more, and
I cannot figure out this one thing or find it documented anywhere.
Here is the code.
strLineNo = Format(txtLineSizeDia.Value, "##0")
If txtLineSizeFraction.Value <> " / " Then
strLineNo = strLineNo & " " & Format(txtLineSizeFraction.Value,
"0/0")
End If
strLineNo = strLineNo & "~"
Lets say txtLineSizeDia.Value = 8 and txtLineSizeFraction.Value = 1/2.
The final value for strLineNo = "8 1/2~". Now I follow the code up to
this point. But then after this there is a simple INSERT command into
a table. Now instead of "8 1/2~" getting inserted into the table,
"8.5" takes its place.
Am i missing something here. Can "~" be used in SQL to change mixed
fractions to decimals?? Please help.
Thanks
Brad