Hi Everyone,
I have table A with a column called ref_id which is a text field. I want to link this to table B that has something called a dep_id that is a number field. I am using a make table query to query Table A and make a temp table where ref_id will be a number.
I have tried using the Val ([ref_id]) expression in the "update to" row. The query runs, but the data type still shows as "text". Does anyone know what I may be doing wrong? Been struggling with this for about a week now.
Juan