AnsweredAssumed Answered

Database not computing

Question asked by GaryVogt on Oct 8, 2013
Latest reply on Oct 9, 2013 by philmodjunk


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.