How do I create a query without using a wizard?
in [Tables]
|
From: jaeymeson on 6 Jul 2008 10:57 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?
From: boblarson on 6 Jul 2008 11:17 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" wrote: > 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?
From: jaeymeson on 6 Jul 2008 12:18 Ok, I guess I have to take the long way around everything I do in Access 2007. Thank you for your response. "boblarson" wrote: > 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" wrote: > > > 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?
From: boblarson on 6 Jul 2008 13:08 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 __________________________________ "jaeymeson" wrote: > Ok, I guess I have to take the long way around everything I do in Access > 2007. Thank you for your response. > > "boblarson" wrote: > > > 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" wrote: > > > > > 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?
|
Pages: 1 Prev: i got a problem!!! Next: Make a Combo Box appear as a Text Box |