Is there a way using the Trim function in Access to remove a space. In the following address field which is coming from a packaged field. It looks like this:
Manhasset, NY 11030-1945.
I would like to remove one of the spaces between NY and 11030-1945 without bringing each field in separately and concatanating them together if possible.