In MS Query, in Exel 2007, the query is selecting the old *.mdb access data base. I checked the SQL statement and it says it's pointed to *.accdb. I have no idea what's happening.
Here is the SQL:
SELECT Bond_Amortization_Variance.Portfolio, Bond_Amortization_Variance.CoaGroup, Bond_Amortization_Variance.MinorType, Bond_Amortization_Variance.AcqMgrGp, Bond_Amortization_Variance.SecID, Bond_Amortization_Variance.IsrName, Bond_Amortization_Variance.GAAP_Amount, Bond_Amortization_Variance.GAAP_Inc_Decr, Bond_Amortization_Variance.STAT_Inc_Decr, Bond_Amortization_Variance.Variance
FROM `J:\Finance\Financial Reporting\INVACCTG\Queries\Access_Queries.accdb`.Bond_Amortization_Variance Bond_Amortization_Variance
WHERE (Bond_Amortization_Variance.Portfolio=200) AND (Bond_Amortization_Variance.CoaGroup=10) AND (Bond_Amortization_Variance.AcqMgrGp='464')
ORDER BY Bond_Amortization_Variance.SecID