Relationship Query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that using a relationship. The parent table list names and
addresses, the child list all association of "last" dates that was entered.
Here is my problem:
When I run this query it gives me all the "last" dates that was entered on
each employee (which is fine) but, if a user didn't enter a date in the
"child table" that record is not list in the query. Why I know I have the
"last" selected in the Total dropdown box, which I need. Is there a way I can
also list the last date entered in the child table AND names and address in
the parent table that don't have dates in the child table?

Thank you all
 
Change the relationship to an outer join. This can be done in query design
view by clicking on the join line, right-clicking and specifying Edit, and
then select the option that will return all records from the parent table.
 
There are only three options when I reight click on the join line. I want to
list all dates that have not been entered on the child table.
 
Right-click on the join line.

Select Join Properties.

Choose the "option button" that says "Include ALL records from <name of the
parent table> and only those records from <name of child table> where the
joined fields are equal." Of course, the real table names will be shown in
the popup box.
 
Back
Top