Solved Excel Power Query not seeing MS Access Query that contains a subquery

[raziel3]

I'm trying to use excel to connect to a ms access query. The query in the attached db is named qryDaily. What may cause excel not to see the query, I know that if your query has the Nz function Excel don't see it. Can someone suggest a workaround (other than to make a table from the query)?

 

[GPGeorge]

I'm trying to use excel to connect to a ms access query. The query in the attached db is named qryDaily. What may cause excel not to see the query, I know that if your query has the Nz function Excel don't see it. Can someone suggest a workaround (other than to make a table form the query)?

If the query is parameterized, Excel can't call it.

 

[MarkK]

Remove the Nz() function from the qryESLD.ENDDATE field.

 

[raziel3]

Remove the Nz() function from the qryESLD.ENDDATE field.

I can't believe that I missed that Nz . Thanks @MarkK

 

[MarkK]

: )