---

MS Access 2003: Enter SQL Statement

This MSAccess tutorial explains how to enter the SQL statement for a pass-through query in Access 2003 (with screenshots and step-by-step instructions).

How to Enter the SQL Statement

Now, type in your SQL statement.

In this example, we've entered the following SQL statement:

SELECT supplier_id, supplier_name, address_line1, address_line2, city, state
FROM suppliers

Now, you'll notice that we left out the semicolon at the end of the SQL statement. Some of the external databases, do not like the SQL statement terminated with a semicolon, so you may have to try your SQL statement with a semicolon and without a semicolon, to see which it accepts as proper syntax.