Using SELECT query within a VBA code in Access

[championss]

Please I need help in running a SELECT query within access VBA. I tried everything I know, but it does not seem to be working. I do not want to use a previously stored query, but instead would like to use the SQL within the code itself. I have seen some examples where you can use a previously saved query, but that will not work for my intended purpose. Thanks.

Championss

[matthewspatrick]

What do you need to do with the results?

[championss]

Thanks Patrick for asking. I just need to put the results into another table. However, I would like to include enough comments around each SELECT statement for others to understand and use, something I cannot do with pre-saved queries.

Thanks.

Chris

[championss]

Thanks Patrick for asking. I just need to put the results into another table. However, I would like to include enough comments around each SELECT statement for others to understand and use, something I cannot do with pre-saved queries.

Thanks.

Chris

[matthewspatrick]

Chris,

Thanks Patrick for asking. I just need to put the results into another table.

In that case, you do not really want a SELECT query--you either want INSERT or SELECT...INTO (otherwise known as "make-table").

However, I would like to include enough comments around each SELECT statement for others to understand and use, something I cannot do with pre-saved queries.

VBA treats anything after a single-quote as a comment.