convert text containg ( '.' ' -' )

[reden55]

I have two parts tables and am attempting to set a value in table A where the parts# match. The part#'s can contain either a "." or a "-". When I try to create an update query, I get the following error,"The expression that you entered has an invalid data value". The fields are "text" in both db's. How can I "convert" the values into text?
Thank you

 

[pdldavis]

Hi, The following worked for me:

Table1 field aa: 1.12
2-23
field ab: The field to contain values.

Table2 field bc: 1.12
2-23
3.0A

sql for update query:

UPDATE Table2 INNER JOIN Table1 ON Table2.bc = Table1.aa SET Table1.ab = IIf([aa]=[bc],1,0);

-updates field ab to 1 if the items match, 0 - no match.

Hope that helps.