Query specifics conundrum

[joolsUK0575]

Hi there

I am trying to work on a query which I am not sure if is possible to do.

Basically I work for a local council and we are trying to return a list of jobs that have not been inspected in three months or more.

The problem lies in that the table that holds the data has a number of inspections that relate to one job.

I have no idea how I can do this. Is there anyone out there that can help?

Thanks for any help

Jools

 

[aleb]

Create a query which will select the job and the date of inspection. Then group the query and in a date field set function max, then in critirea type:
<date()-90

 

[joolsUK0575]

Thanks!

Worked a treat