[MS_AccessPros] Open query based on SQL withing VB

 

How do I open a query based on SQL I write within VB? I want to try doing this rather than creating and using a stored query, as in DoCmd.OpenQuery "qryName"

stSQL = "SELECT Source.DMADES, Count(Source.TN) AS CountOfTN " & _
    "FROM Source GROUP BY Source.DMADES ORDER BY Count(Source.TN) DESC;"

Thanks

Adam

__._,_.___

---

Posted by: runuphillracing@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___