You need to make an Update Query. In the Query Builder, make a Select query
with the one field ([Item]). Then change the query to an Update Query
(there's a button on the tool bar), and put the expression you used below in
the UpdateTo row of the field. Then run the query with the Run button.
--
--Roger Carlson
MS Access MVP
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L
"Kat" wrote in message
...
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?