All,

Thank you for the help!

I attached a workbook relating to my question...

Both fields below are sub string calculations that produce the same value. However, when I try to join on these calculations it does not work. If you go to the data source tab within the workbook attached you will be able to see that an inner join does not produce any results. If you select full outer join you can see the values.

Archer Calc

Notes Calc

Please help!!!!