Hoping you can help.
I'd like to use DLookup, DCount etc. on a SQL string held within the VBA code itself. Something like:
stSQL = "SELECT * From Contacts"
MsgBox DCount("Contact_ID", stSQL, "Deceased = False")
I'm trying to avoid creating lots of queries.
I'd like to use DLookup, DCount etc. on a SQL string held within the VBA code itself. Something like:
stSQL = "SELECT * From Contacts"
MsgBox DCount("Contact_ID", stSQL, "Deceased = False")
I'm trying to avoid creating lots of queries.
Generate Query Definition
