SQL Query runs as pass-through but VBA returns error

@pjwhitfield

There is the string generated by code

HTML Code: 

Again, this query would run in access as pass-through without any issues.

@mrrice

Yes, since I am naming the results as TotalItems

Thanks for the help.