By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Where to write SQL query

P: 40
Delerna I click on New Query-->Screen Appears named New table, I choose Design View From there & click OK--> After Clicking the OK,A Screen is opened in which we have to speicify Fieldname,DataTYpes & description.

No Show table screen is opened.
Apr 9 '08 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
This thread belongs in the Access forum not the SQLServer forum.

Hi Yogesh
You are creating a new table

You need to create a new query

Open Access
Click on the Queries tab
Click New Query
Choose Design View
Close the Show Table Window
In the View menu click SQL View
voila... now you can write an SQL query

Obiously you can do this also with existing queries that were created with the wizard
Open the query in design mode
In the View menu click SQL View
And there is the query

This is a good way to learn how to write queries with SQL
Just create it with the wizard and then take a look at how the wizard wrote the query
Apr 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.