Let me clarify, if I can.

We're looking for projects  that are In Progress.  The definition of a
job that's still In Progress is one where there is at least one
payment yet to be made.  All jobs have progress payments and when the
last payment is made, the job is Complete, no longer In Progress.

It's irrelevent how many tasks there are, although typical is from 20
to 30, of which 5 to 10 would require a Progress Payment at completion
of the task.  So the "correct data" would be only those jobs that had
at least one unpaid Progress Payment as of that particular date. We're
not looking at a range of dates, just one point in time.

Once we retrieve the records, then we can calculate how much money is
in the "pipeline".  Money that is due the company as of that day.

An example.  We're going to build a patio cover.  There are 15 tasks
from "Survey site", "deliver materials", to "final inspection".  The
total job is $15,000.00 with 5 payments to be made at intervals. As
long as at least one of those payments has yet to be made (date paid
and amount paid are Null), then that customer record should be
retrieved.  Once he makes his final pmt, we don't want it.

Hope that helps.

Paul Fenton