totn Access 2003 Pass-through Queries

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.

Microsoft Access

Your query should now look like this.

Microsoft Access