using Access to try SQL codes

  • Thread starter Thread starter J_J
  • Start date Start date
J_J,

I am not entirely clear what you mean. But you can do these steps:
- go to the Queries tab in the Database Window of your Access database
- click on 'New'
- accept the default 'Design View' and click 'OK'
- click 'Close' on the Show Table window
- select 'SQL View' from the View menu
- enter your SQL statement in there
- run the query by clicking the toolbar button with the red [!] icon
 
Thanks Steve,
I' ll follow the steps...as you have suggested.
J_J

Steve Schapel said:
J_J,

I am not entirely clear what you mean. But you can do these steps:
- go to the Queries tab in the Database Window of your Access database
- click on 'New'
- accept the default 'Design View' and click 'OK'
- click 'Close' on the Show Table window
- select 'SQL View' from the View menu
- enter your SQL statement in there
- run the query by clicking the toolbar button with the red [!] icon

--
Steve Schapel, Microsoft Access MVP

J_J said:
Hi,
How can I try some SQL commans or codes with access?
Thanks in advance
J_J
Click to expand...
Click to expand...
 
Back
Top