Sergey,
Good insight. What really happens is that there is a "mandatory" once
a year or every two year inspections, which is classed (insptype),
and then there other types of inspections - new construction or renovations,
which are mechanical - heat & air, electical, plumbing, etc. - may occur
who-knows-how-often. What I am looking for are the mandatory inspections
which I can pick up with a WHERE clause. Yes, it's possible for them to
occur more frequently than once a year, but it's much more likely that they
are late rather than early.

Further, there are a lot of factors in the report, and in reality,
the report is more political than operational. And, since the
inspections have to happen within the "next fiscal" year, an inspection
that is due to happen once every "fiscal year could be done 729 days
apart every other year and still be technically within the rules as they
are established.

Kinda funky, huh?

Now, about that SQL syntax...


Thanks for taking the time,

sjwilson