Re: Linking tables on fields with different data formats
It looks like your SpiderID is being held as a string. You need to explicitly convert this to the same format as the field you are joining to. If there are string fields as well as integers then the safest may be to convert both into strings... Be sure to trim etc. if there are any chances of trailing / leading spaces.