How do I remove unsolicited characters from a query result?

M

mr brownstone

I am trying to create a hyperlink through information in two tables which I
am joining through concantention. I am getting a dash surrounded by spaces
in the middle of the 2 fields which I do not want. Example of the problem:
What I am ending up with c:\program files\aiar\ - 35010300067
What I want to end up with c:\program files\aiar\35010300067

I believe my problem is that Access is seeing the hyperlink in parts rather
than the whole.

I am using Access 2002.
 
Top