The Comments table is linked to the Job table. The Job table stores all pertinent info except the comments. The link is 1 Job record to many Comment records.
I have Comments in the Details section, Key in my lowest group(a counter starting at 0 for each date), then Date group, then Job in my highest level group.
I simply (or not so simply) want to collect a running total of hours worked on each Job record.
When I try to evaluate for each record, I get multiples due to the several Comment reocrds(I understand why).
When I try to evaluate on change of the Date Group it only gives 1 record for each date(I understand why).
When I try to evaluate on change of the Key Group it works until I only have 1 record for the date. Then it sees "0" twice (1 each for 2 different dates) and doesn't see it as a change. THis one I don't understand because it is within the date group - shouldn't that count as a group change?
Thank you for your time.