I'm still very new to access.
I'm trying to create a database tracking monthly inspections.
I have two tables
[Housekeeping] : contains the form data once an inspection is completed
[Area Owners] : Cotains the areas needing inspections and who owns them
I am trying to find a way to run a search for what inspections HAVE NOT been completed for a given month. But if the inspection has not been completed, then there is no record in the [Housekeeping] table.
How do i get the names of the areas to show up in a query, for inspections that have not been completed for a given month?
Thanks for your help.
I'm trying to create a database tracking monthly inspections.
I have two tables
[Housekeeping] : contains the form data once an inspection is completed
[Area Owners] : Cotains the areas needing inspections and who owns them
I am trying to find a way to run a search for what inspections HAVE NOT been completed for a given month. But if the inspection has not been completed, then there is no record in the [Housekeeping] table.
How do i get the names of the areas to show up in a query, for inspections that have not been completed for a given month?
Thanks for your help.