MS Access 2003: Add SQL to Query
This MSAccess tutorial explains how to add the SQL statement to a pass-through query in Access 2003 (with screenshots and step-by-step instructions).
Write SQL for your Pass-through Query
Since you are choosing to create a pass-through query instead of linking to the table, Access does not know the table or field names in your external database. So you will have to write your SQL without the help of the Query Builder in Access.
As a result, you'll need to switch your query to the SQL View. To do this, select SQL View from the Toolbar. See picture below.
Your query should now look like this.
Advertisements