I’m looking for help with coding a LOOP which I’ve never done before. Do I do this in the SELECT statement or the LOAD statement? Basically, what I want to do is create a StartDttm for each log entry associated with a Job Report. As is the timelog table only stores the number of hours that a particular entry took. Their dates would be derived from the Job Report StartDttm with the first entry's StartDttm equaling the Job's StartDttm. The remaining Log Entries StartDttms would be derived by adding the HrsDur of the previous ones to the Job Report StartDttm or possibly from the previous derived StartDttm.
CASE WHENLogSeq# = 1 THEN RptStartDttm // -- from here down is just my thoughts on the logic
Thanks a lot for your help. I don't really understand how the code works so I'll have to study it more when I've got the time. I like that it's just one line that does the trick. However, I did have to change Timestamp#() to Date() in my code for it to work and display properly.