I posted a question yesterday about a problem I was having bringing the results of a query into Excel from Access. No solutions were found.
After doing some testing, I believe the problem may be with this subquery:
It asks me to enter a parameter for tblOSHAHistory.ClaimNum, despite the fact that I haven't assigned any parameters.
I'm an SQL novice, but I don't think I've missed anything here. My SQL produces the desired results in Access and returns a null set in Excel.
After doing some testing, I believe the problem may be with this subquery:
Code:
SELECT Max(O.ChngDate)
FROM tblOSHAHistory AS O
WHERE O.ClaimNum = tblOSHAHistory.ClaimNum
It asks me to enter a parameter for tblOSHAHistory.ClaimNum, despite the fact that I haven't assigned any parameters.
I'm an SQL novice, but I don't think I've missed anything here. My SQL produces the desired results in Access and returns a null set in Excel.