change data type in query through a link table

[hoachen]

I don't know how to use the function to change the data type in my query. I
have two link tables and i want to link them but, the column of both link
table have different data type. I can;t change the data type in table due to
it is a link table.

Is there a way i can change the data type from number to text OR text to
number?

 

[hoachen]

Actually, the column is have bunch of text then follow by the number (AMDKFD:
124556 which is text DataType). I replaced it used Replace function in the
query and leave only the student number. Can i change it here to number
DataType?

Student#: Replace([OutputStr],"ABC:STUDENT#","")