2 fields, one in each table. Both fields are identical, short text, 255 char max. The join query on these two fields works perfectly 95% of the data, Access can tell that the join fields have identical data and joins the tables accordingly. But for a handful of people it just does not...