easiest way to run SQL statments in Access

[lee]

Newbie question:

I'm looking for the easiest way to run SQL statments in Access. I'm
getting confused by th GUIs - I'm just looking forhow to run SQL on a
table- thanks

[tina]

from the database window, go to the Queries tab and click New. you can use
the query design interface to build a query, or if you're comfortable
writing SQL statements, you can go to the SQL pane from View on the menu bar
(in query Design view), and just write the SQL freehand.

hth
"lee" <go******@worldpost.comwrote in message
news:11**********************@e16g2000pri.googlegr oups.com...

Newbie question:

I'm looking for the easiest way to run SQL statments in Access. I'm
getting confused by th GUIs - I'm just looking forhow to run SQL on a
table- thanks

[Allen Browne]

1. Create a new query.
2. In the first dialog, just choose Design view.
3. Cancel the Add Table dialog.
4. Click the View button (left end of toolbar), which defaults to SQL View
(since you added no table.)
5. Type in the SQL Statement you want.
6. Click the Run button on the Toolbar.

If you prefer, you can execute action or DDL queries from a command prompt.
Open the Immediate Window (Ctrl+G), and Execute the query statement, e.g.:
CurrentDb.Execute "DELETE FROM Table1 WHERE (False);", dbFailOnError

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"lee" <go******@worldpost.comwrote in message
news:11**********************@e16g2000pri.googlegr oups.com...

Newbie question:

I'm looking for the easiest way to run SQL statments in Access. I'm
getting confused by th GUIs - I'm just looking forhow to run SQL on a
table- thanks