2 Replies Latest reply on Aug 11, 2009 4:57 AM by cdubbya

    How to get the data from previous to last repeating field?

    cdubbya

      Title

      How to get the data from previous to last repeating field?

      Post

      Howdy, 

       

      I know, I know, I've read all the issues with repeating fields.  But, what's done is done, and I've not much time to muck more in the DB.  

      Question: In a report, I can get the  Last repetition and display it easily (well, it's easy now cause some nice folks here helped me) - and of course, now management would like to see how that data relates to the one before.  Oh, bother.  

      I can't use get repetition number, because it may be different depending on the record - 

       

      Record  |  Rep1  |  Rep2 |  Rep3 | Last Rep |  Previous Rep | 

      yoyo          2           3        2             2

      gogo          1            1       1

      momo        2           1        1

       

      Get it?

       I want to show in "Previous Rep" that yoyo was 3, gogo was 1, and momo was 2. And, of course, it updates as each record is updated. 

      Something like Last Repetition -1, but Lord help me, I'm just not that bright.

       

      Can you help me with a calc (I assume this is what you'd use) that will work for this?