SQLStatement Required Variant A string expression that's a valid SQL statement for an action query or a data-definition query. It uses an INSERT INTO, DELETE, SELECT...INTO, UPDATE, CREATE TABLE, ...

Remarks Use the RunSQL action to run a Microsoft Access action query by using the corresponding SQL statement. You can also run a data-definition query.

AFAIK the DoCmd.RunSQL is only used for "action" queries such as append, delete, etc. <BR>To achieve what you want, you'll need to create a new recordset based on your SQL statement.

My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to ...