using Access to try SQL codes

S

Steve Schapel

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
 
J

J_J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Access to try SQL codes 6
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
VBA word change keys 0
Office 365 Outlook adding unwanted HTML to Email Body 0
Link a text box based on drop down box with four options MS Word 365 0
Client Access File Transfer from Excel 2010 3
Need help modifying code 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0

Top