Spikemannen
Instructor
Hi...
This is my code so far:
My table tblInvoice looks like this:
InvoiceID
InvoiceDate
CompanyId
BillTime
Until
In this form I choose a InvoiceDate and a Company.
Now in want my query to get the sum for tblArrend.EstTime where the tblArrend.Finished date is between tblInvoice.Until.value and the last record in the table where I have choosen the same CompanyID.
Can anyone help me, please...?
Best Regardz,
Spikemannen
This is my code so far:
Code:
SELECT SUM(tblArrend.EstTime) AS SumForPeriod
WHERE tblArrend.CompanyID = tblInvoice.CompanyID
AND tblArrend.Finished<tblInvoice.Until
My table tblInvoice looks like this:
InvoiceID
InvoiceDate
CompanyId
BillTime
Until
In this form I choose a InvoiceDate and a Company.
Now in want my query to get the sum for tblArrend.EstTime where the tblArrend.Finished date is between tblInvoice.Until.value and the last record in the table where I have choosen the same CompanyID.
Can anyone help me, please...?
Best Regardz,
Spikemannen