[thelist] Better way to do this (SQL)?

[Ed McCarroll]

> So _this_ is the answer to how to run the queries I was stuck 
> on last week!

I really like it when, after I've followed a thread, the originator comes
back with his/her final answer.

<tip type="MS Access" author="Ed McCarroll">
In VBA, you can use the following:
  DoCmd.RunSQL "SELECT * FROM ..."
to run an SQL query that you've hard coded, or put together on the fly.

You can also use the following:
  DoCmd.RunSQL currentDB.QueryDefs("MyQueryName").SQL
to run an SQL query that you've created and saved using the Query Builder.
</tip>

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                             http://www.ComSimplicity.com
(310) 838-4330                      PO Box 654, Culver City, CA 90232
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -