S
stephen.belyea
In the database I am working on, I would like to be able to create a
report with a list of all the properties in the database, accompianed
by the date of when the property was inspected. Some properties have
never been inspected, and therefore do not have an inspection date -
or even an entry in tblInspection. Is there a way for me to build a
query that displays all of the properties as well as the date they
were inspected, even if they were never inspected?
tblProperty.PropStreet = is the field for the property, and
tblInspection.InspDate = is the field for the inspection date.
Thanks!
report with a list of all the properties in the database, accompianed
by the date of when the property was inspected. Some properties have
never been inspected, and therefore do not have an inspection date -
or even an entry in tblInspection. Is there a way for me to build a
query that displays all of the properties as well as the date they
were inspected, even if they were never inspected?
tblProperty.PropStreet = is the field for the property, and
tblInspection.InspDate = is the field for the inspection date.
Thanks!