ADO To Retrieve Records From MS ACCESS Database

I am using ADO to retrieve records from an MS ACCESS DB in Excel. All my queries work fine but I am having problems with subqueries. My subqueries work fine in ACCESS but when I execute them via ADO I get the following error message:'"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect".

with the correct syntax. Alternatively I was thinking of creating a view in ACCESS but that seems not possible.

PHP Code:

Sub retrieve_loan_details()
Dim Provider As String
Dim Source As String
Dim sConn As String
Dim sSql As String
Dim rep_per As Date

[Code]...