Coverting a field to text on the fly

[DanAuber]

I am trying to join two tables on a field which is text in one and number in the other.

I want to do it like this

where textfield = TEXT(numberfield)

but I don't know the command to use for the TEXT bit - can anyone help ?

 

[Ashank4vba]

Maybe u could use the CStr function

 

[DanAuber]

I can't see this function in my Access 97...

 

[PHV]

Either:
WHERE Val([text field]) = [number field]
Or:
WHERE [text field] = [number field] & ""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886