Hello all,
Help please!! As in the title I am trying to extract a list of required equipment inspections- to show the last date the equipment was inspected, as well as those pieces of equipment that have never had an inspection. The frequency of checks are based upon the equipment category (ie vehicle or lifting table) and the check type (ie user check or service or MOT etc.)
I can get a query to show me all checks that need to be done.
I can get a query to show me the last check that has been carried out on each piece of equipment.
What I cannot seem to manage is to combine these.
Here is my structure (which I am now starting to doubt is correct):
Thank you in advance for any help or advice