|Subject||RE: [firebird-support] Difficult to assign a subject title|
>>If there is a relationship between HrsWorked and the invoice whose dateHi Helen,
>>you want to refer to
Yes there is a relationship between HrsWorked and the invoice. I need the
resultant dataset to look as follows:-
ForkliftOID InitHrs HrsWorked InvoiceDate
001 0 40 10/10/2006
001 40 100 10/11/2006 etc...
On the 10/10/2006 the max invoicedate before the 10/10/2006 was nul(hence 0
as InitHrs). On the 10/11/2006, the max invoicedate before November 2006 was
Oct 2006, hence the HrsWorked as InitHrs for the 10/11/2006 invoice period.
The max invoicedate prior to the current invoicedate serves as the InitHrs
for the current invoicedate being processed.
I hope this clarifies things. Thanks, Dion.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 17/05/2006