I have a basic table in an Access database. In that table, I have a 10-digit numeric field that is stored as Long Text (leading zeros are significant). I extracted the unique values from that field in the table, and created a new table/field with the same Long Text data type. When I try to join that field back to the original table, I get the error: Cannot join on Memo, OLE, or Hyperlink Object. Is there a work around for this, or a known problem I need to address?