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 ...