Where to write SQL query

[Yogesh Sharma]

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,DataT Ypes & description.

No Show table screen is opened.

[Delerna]

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