Missing data

  • Thread starter Thread starter gooch
  • Start date Start date
G

gooch

I have created a database of students records using 10 or more
tables. I created a form to show the data from the tables by the
student id. My problem is that unless the student is listed in every
table the data does not show in the form. That student is missing all
together.
 
In the Query Builder, click on the join lines between the tables and select
the appropriate option. It seems you just took the default, which is a
"equi-join" (show the record only if it exists in both tables), but you want
one of the (show all records from table xxx and only those that match from
table yyy).

Larry Linson
Microsoft Office Access MVP
 
In the Query Builder, click on the join lines between the tables and select
the appropriate option. It seems you just took the default, which is a
"equi-join" (show the record only if it exists in both tables), but you want
one of the (show all records from table xxx and only those that match from
table yyy).

 Larry Linson
 Microsoft Office Access MVP






- Show quoted text -
Click to expand...

I am not using a Query Builder and I do not know how. I just linked
the tables and cteated the form.
 
gooch said:
I am not using a Query Builder and I do not know
how. I just linked the tables and cteated the form.
Click to expand...

Only two places I know to "link tables" are (1) in the Relationships window
and (2) in the Query Builder, unless you are choosing to write your own SQL
from scratch. Some call it "Query by Example", but the Official name of the
Access functionality that is used when you click the Query tab, and click
New in the menu is "Query Builder".

So, can you clarify for me _how_ you _linked the tables_? In the Query
Builder Screen, you would have the tables in the top part of the dialog as
data sources, click a field in one and drag it to the corresponding in the
other.
That will result in a join, represented by a line, click the line to
highlight it, then right-click it and select join properties.

Larry Linson
Microsoft Office Access MVP
 
Back
Top