Spikemannen
Instructor
Hi!
I have five tables:
tblCompany
CompanyID
CompanyName
tblSubject
SubjectID
Subject
tblHandler
HandlerId
Handler
tblArrend
ArrendID
Company
Arrived
Subject
Arrend
Handler
Prio
Description
Status
Finished
Time
tblInvoice
InvoiceID
Company
InvoiceDate
Until
Time
For the function I'm after I will work in tblInvoice.
I choose a invoice date (presumably today), then I choose a date in the tblInvoice.Until, when I leave that field I want a questiothat calculates all tblArrend.Time for every arrend that has a finished date before tblInvoice.Until for the active post but after the last posts tblInvoice.Until value. AND the time will only be calculated for thoose arrends that has the same Company value as tblInvoice.Company.
How to do this? Please, help me...
Best Regardz,
Spikemannen
I have five tables:
tblCompany
CompanyID
CompanyName
tblSubject
SubjectID
Subject
tblHandler
HandlerId
Handler
tblArrend
ArrendID
Company
Arrived
Subject
Arrend
Handler
Prio
Description
Status
Finished
Time
tblInvoice
InvoiceID
Company
InvoiceDate
Until
Time
For the function I'm after I will work in tblInvoice.
I choose a invoice date (presumably today), then I choose a date in the tblInvoice.Until, when I leave that field I want a questiothat calculates all tblArrend.Time for every arrend that has a finished date before tblInvoice.Until for the active post but after the last posts tblInvoice.Until value. AND the time will only be calculated for thoose arrends that has the same Company value as tblInvoice.Company.
How to do this? Please, help me...
Best Regardz,
Spikemannen