How to Query

  • Thread starter Thread starter hon123456
  • Start date Start date
H

hon123456

Dear all,

In SQL Server, I can use Query Analyzer to run SQL query and
to debug the query. In acess, there seems no function like Query
Analyzer. If I want to run and test a SQL, how can I
do that in Access.?

Thanks.
 
1. Go to the Database Window
2. Go to the Queries tab
3. Click on New Query
4. Click Design View
5. Don't select a table and click Cancel
6. Click the SQL view button
7. Type or paste the SQL into the window
8. Click the Datasheet View tool button to view the results of the query.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
1. Go to the Database Window
2. Go to the Queries tab
3. Click on New Query
4. Click Design View
5. Don't select a table and click Cancel
6. Click the SQL view button
7. Type or paste the SQL into the window
8. Click the Datasheet View tool button to view the results of the query.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials athttp://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.







- $Bp}<(Ho0zMQJ8;z(B -
Click to expand...

Boblarson. Thanks for your help.
 
Back
Top