How do I create a query without using a wizard?

[jaeymeson]

I am starting to use Access 2007. I have used previous version of Access. How
do I create a query without having to use the query wizard? I use to be able
to select the table I wanted to use and click the New Object icon on the
toolbar but now the only choices I have makes me do more work. How do I get
to the SQL window without having to use the wizard?

 

[boblarson]

Click on CREATE > QUERY DESIGN and then add the tables you want and go from
there.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[jaeymeson]

Ok, I guess I have to take the long way around everything I do in Access
2007. Thank you for your response.

 

[boblarson]

Not everything but in this case yes. And I don't like that either because I
used to do it the way you did as well.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________