Hi,
Does anyone know if it's possible to compare a text field with a number field in access, by using some kind of toString function?
Cheers.
Printable View
Hi,
Does anyone know if it's possible to compare a text field with a number field in access, by using some kind of toString function?
Cheers.
Look up the help on type conversion functions...
Cstr(expression) will convert a numeric type to a string there are numerous others however in the on-line help.
I am guessing here but what type of comparison are you making Ascii or numeric?
I have also found the eval(expression) function extremely useful in this area.
debug window example:
?"1+1" --> "1+1"
?eval("1 + 1") = 2 --> true
Hope this helps, perhaps provide more info if it does'nt.