Type mismatch in expression

[ant1983za]

I have two tables in a query joined by a ID field. The problem is in the one table the ID fiels is a text format and in the other table its a number format so the query builder doesnt like that and gives me the Type mismatch in expression error.

Theres no way around it though; i need it to be those formats in its respective tables for reasons i wont go into here for simplicity.

Any way around this?

 

[jdraw]

In overview your situation is like comparing apples and oranges. You need to compare orange to oranges (or apples to apples).
Tell us more about why you need these IDs to be of different datatypes.

 

[pr2-eugin]

Write a manual SQL query wrapping the Text to Long using CLng function..