Missing records in query

[Guest]

May be simple but I cant figure it out.
I have one table that holds property details and another that holds
appointment dates for properties. I have a one to many relationship set.
(one prop many appts).
I need a query that will give me all my properties and details of any
appointment set. When I have created the select query I only get back
property records where there is an appointment made. I would really like to
see the propety details with a blank entry in the appointment field.
Would be grateful for any help available.
Thanks

 

[Rick Brandt]

May be simple but I cant figure it out.
I have one table that holds property details and another that holds
appointment dates for properties. I have a one to many relationship
set. (one prop many appts).
I need a query that will give me all my properties and details of any
appointment set. When I have created the select query I only get back
property records where there is an appointment made. I would really
like to see the propety details with a blank entry in the appointment
field.
Would be grateful for any help available.
Thanks

Double-Click the line joining the two tables in the query. The resulting
dialog should be self-explanatory.