Linking numeric fields

When comparing file extracts imported from various systems into Access, I occasionally run into problems linking numeric fields (field values that should link, but do not). Often 99% of the records match fine, but a few do not. I am careful to format the numeric fields tables as double, and even have updated the fields using CDbl(fieldname) but I still get intermittant linking problems.

Is there any way I can "normalize" the numeric fields to avoid this issue?

Any assistance is greatly appreciated.

One of the things that I always do when linking in data from different sources, is to create a dummy record with each field containing data that will force the datatype. Access looks at the first record to determine the datatypes. So, if I want the field to be a double, I put in 99.9999 for the field in my dummy record. AAA in text fields and so on. Then, I delete that record. It is able to make for better consistancy for me.

HTH