Prev: Text value type is calculated on INSERT
Next: Sorting records based on a couple or many criteria items from
From: CSnTexas on 21 Mar 2010 18:30
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?
From: John W. Vinson on 21 Mar 2010 20:24
On Sun, 21 Mar 2010 15:30:01 -0700, CSnTexas
>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
Jeff Conrad's resources page:
The Access Web resources page:
Roger Carlson's tutorials, samples and tips:
A free tutorial written by Crystal:
A video how-to series by Crystal:
MVP Allen Browne's tutorials:
John W. Vinson [MVP]