In Access 2010, how do I create a SQL query?

E

ew68

In older versions of Access, there was a View -> SQL View menu button. How
do I get the SQL View with Access 2010? I need to create a query which
contains a join operation. I don't think I can do this with the Query Design
view.
 
A

Antoine Yassa

I searched for the same issues. I discovered accidentally that by setting the cursor in the Design View of the preliminary Query, the Contextual menu (Right Click) offers the choice of SQL View that was much more easy to access in earlier versions of MS Access
 

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

Sharing Access MDB or Accdb with client using older or newer version of Office 1
Descenders clipped 0
Looking to flip text in Excel file (2010) 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Left Join query not working in Access 2010 0
Access 2002 change report header text 0
How do I clear a form? 0
Create own tool bar Mac 2015 0

Top