I have a Access database that has one table with a field called division.  The database is full of race car drivers in several divisions. I have access queries that selects drivers and their race results by division. I need to select records by using the queries I have in Access.... can this be done??

Statement I am using to select all records:

strSQL = "SELECT thursdaythunder.* FROM thursdaythunder order by car;"

The database is named thunder, the table is named thursdaythunder and some of the queries are named: bandits, masters, pro... etc

Try this

strSQL = "EXECUTE bandits;"

And if you have query's that require parameters, you could just do so like this.

strSQL = "EXECUTE bandits Param1, Param2;"

Where param 1 and 2 are the values you want to pass into the query.

Hope this helps

Thanks - one good answer leads to another dumb question!

I am new to this - have never used the Execute statement..

It worked...

I also finally got it to work with the following:

strSQL = "SELECT * FROM Masters order by [6/5/03];"

I tried to order the Execute command but it did not work..

strSQL = "EXECUTE masters order by [6/5/03];"

Is it better to use the execute statement...

Also I would like to have a dropdown box with the divisions in it that would then pass the desired statement to the execute statement or the one I got to work.

Can that be done??

You also dont have to use the execute command to fire the query, here's a article that may explain it a little better.

http://www.xefteri.com/articles/apr302002/default.aspx - http://www.xefteri.com/articles/apr302002/default.aspx