I’m trying to build a SQL statement in VBA that I can run to generate a recordset.
The difficulty is that this is a complex statement that requires me to build a statement in SQL and then run it by executing sp_executesql. But the recordset isn’t even being opened.