Database not computing
I wish I could just send the whole file.
I have a database that was working fine until i inserted records between existing records. It is nothing more than getting the last value of a previous record and using it as the first value of the next record.
If(Get Record Number Previous=0; ""; GetNthRecord ( Ending Balance ; Get Record Number Previous ))
Seemed to work fine until I inserted some new records. the record ID has no correlation to the record number.
Very frustrating. I should be able to get a value of a previous record and use it. I can't.