I need HELP! O(o_o)O
I am suriously stuck, Debugging code without documentation is a nightmare for trainee programmers.
Basically I need to loop a record set called Summary and Validate all informtion containned within it, I assume the way I can accomplish the task but am not sure how to implement it, right next within the loop I have to grab a value from a field called Carried Forward in that record and then set the value of Balance C/F in the next record to the grabbed Carried Foward Value from the previous record.
But this can apply to only certain records for example within my ContractorID field in the table it relates to multiple instances of certain contractors, the first instance of a contractor will contain no Balance C/F and the last instance may contain a Carried Forward value but I don't want to grab the last value because it would wreck the other records.
I think I have to create some kind of SQL statement an APPEND query but don't have the expertise. HELP ME please..
Any ideas would be nice, And also tell me if you want me to explain more, can you guys understand me?