Access Append query deleting blank spaces in hyphenated column names ex: [Territory - Desc]
Posted on 2006-06-19
I have several columns with the format text sp hyphen sp text. examples are [Territory - Desc] and [Ship to - City]. When I create append queries, the destination field name becomes reformatted (blank spaces removed) after saving the query. Oddly, this is only happening to the [Territory - Desc] field. The [Ship to - City] field is fine. Changing the column name is easy, rewriting the all of the queries and reports that feed off of the existing column name would be a huge pain. I just want Access to stop reformatting the destination field name in the append query.
This question is on your site a couple of times, but no real solution is currently out there.