type casting in access

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.

[Richyrich]

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.