We are using an excel workbook with multiple access queries. Our server changed so we need to change the path references for the access database.



However when I add the new path, the path reference spills over to the next line in my SQL statement.

So I go from this (affected lines in bold):

SELECT tblNewFundHistory.Date, tblNewFundHistory.NAV, tblNewFundHistory.`Accrued Income`, tblNewFundHistory.Income, tblNewFundHistory.Factor
FROM `H:\SIProgram\DATA\SIPData`.tblNewFundHistory tblNewFundHistory
WHERE (tblNewFundHistory.`KJ #`=?)
ORDER BY tblNewFundHistory.Date


To this

SELECT tblNewFundHistory.Date, tblNewFundHistory.NAV, tblNewFundHistory.`Accrued Income`, tblNewFundHistory.Income, tblNewFundHistory.Factor
FROM `G:\JPK\Common\SIProgram\DATA\SIPData`.tblNewFundH istor

y tblNewFundHistory
WHERE (tblNewFundHistory.`KJ #`=?)
ORDER BY tblNewFundHistory.Date


Note that I cannot expand the window to get the "y" bumped to the next line back up.

Access then ask me to enter a parameter, perhaps because it is trying to interpret the "y" as a table or reference?

I figure there is an easy fix for this but I am an inexperienced user. Thank you for any help.