V9, from AccessDB - The accessDB is fed by another program, not easily customized. The field that I want to use as a number is a text field assigned by the program meaning I cannot change the field type in the database. In my report I keep getting the 'string is non-numeric' error. I have tried the ToText function with no luck. Is there another way to convert or is it just not possible?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Text to Number?
- Thread starter sandora
- Start date
synapsevampire
Programmer
It may be that it has more than just numerics in it, so use:
if isnumber({table,field}) then
val({table.field})
else
0
-k
if isnumber({table,field}) then
val({table.field})
else
0
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question