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