If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a Query based of two diffent data tables
Access 2000- I am trying to create a Query based off two tables.
I am working with two tables and the only matching field out of both tables is an account number. How do I write an expression or criteria in the design view that will allow the account number to match out of each table to gather the rest of the information from both table based off the account numbers? |
#2
|
|||
|
|||
Creating a Query based of two diffent data tables
On Sun, 21 Mar 2010 15:30:01 -0700, CSnTexas
wrote: Access 2000- I am trying to create a Query based off two tables. I am working with two tables and the only matching field out of both tables is an account number. How do I write an expression or criteria in the design view that will allow the account number to match out of each table to gather the rest of the information from both table based off the account numbers? Create a Query in the query design window. Add both tables to the query window. If Access doesn't do so automatically, drag the account number field from one table (the "parent") to the corresponding field in the child table. Select whatever fields you want to see into the query grid. You'll be doing this a lot, and should become comfortable with both the query grid view and SQL view - you can click View... SQL to see the latter (it's the "real" query, the grid is just a tool). If you need help with a query from the newsgroups, copy and paste the SQL to a message here. Here are some resources that might help you up the steep and rocky learning curve... Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|