Using Query SQL in VBA Module Access 97

[John Cole, Jr.]

I have an Access 97 database that is used to transfer data from one
computer system to another. The export fields are fixed, and each
project I work requires data from different fields in the input
computer system. Rather than create several mini databases to cover
each of the job situations, I would like to use "Select Case" in my
module and input the SQL statement from each of the queries. How do I
use the SQL from the query in my module?

 

[Van T. Dinh]

You can use the SQL Property of the QueryDef Object which is the Query
object in code.

Check Access VB Help on QueryDef and its Properties.