Is there a way to join an integer to a string, that always contains an integer, in Microsoft Access
===

In Microsoft Access, I have two linked tables which I can't change the structure of.

One of these tables contains an ID in integer format, the other contains the same ID, but in string format.

I want to join on these fields, but, obviously, MS Access isn't letting me.

Is there a way, possibly using casting or something similar to create this join?

Thanks