>>If there is a relationship between HrsWorked and the invoice whose date
>>you want to refer to

Hi Helen,

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