I have an update query design with the source and the destination tables in the query designer. But the joined fields are a text field in one table and a number field in the other table. So naturally I'm getting a type mismatch error. Is there some way to convert the text field to a number? It will always truly be a number.
I tried ID: Val([textfieldname) but that didn't work.