Relationship Query question

[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

 

[Ken Snell [MVP]]

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.

 

[Guest]

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.

 

[Ken Snell [MVP]]

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.