Won't show all records

  • Thread starter Thread starter Jacques Latoison
  • Start date Start date
J

Jacques Latoison

I have three tables
Sites
Contractors
Subs
Sites is one-to-many to Contractors which is one-to-many to Subs

Every Contractor doesn't have a Sub (nor will they). Whenever I add the
Subs table to a query or report they will give records where Subs exist.

I need to show all records whether the Contractors have Subs or not.

Thanks beforehand,
 
In the query, right-click the relationship line that
connects the two tables Contractors and Subs. Click Join
Properties. Choose the option that says Include ALL
records from "Contractors" table and only those records
in "subs" table where the joined fields are equal. That
will show all of the contractors whether they have subs or
not.

HTH,
RB
 
That works well.

Thank you.


| In the query, right-click the relationship line that
| connects the two tables Contractors and Subs. Click Join
| Properties. Choose the option that says Include ALL
| records from "Contractors" table and only those records
| in "subs" table where the joined fields are equal. That
| will show all of the contractors whether they have subs or
| not.
|
| HTH,
| RB
|
|
| >-----Original Message-----
| >I have three tables
| > Sites
| > Contractors
| > Subs
| >Sites is one-to-many to Contractors which is one-to-many
| to Subs
| >
| >Every Contractor doesn't have a Sub (nor will they).
| Whenever I add the
| >Subs table to a query or report they will give records
| where Subs exist.
| >
| >I need to show all records whether the Contractors have
| Subs or not.
| >
| >Thanks beforehand,
| >
| >
| >.
| >
 
Back
Top