I have (2) tables that were imported into access from excel. However, the
data has a combination of letters, numbers, and dashes in it. That will
make the data type as Text. Included in the data are spaces before and after
the text. I want to remove the spaces so that I can create a query to match
two same fields from diffrent tables. In a query I built a field that should
have removed the spaces but it did not. This is what I did: ItemNew:
Trim$([26774]![Item]). But it did not remove the spaces. Until I remove the
spaces I can not match the data from both tables. What am I missing?