I have to generate the Holes between values in two fields in a table

Start_num  End_num
      0                   0
      1                   1
      2                   2
      3                   3
      5                   5
      6                   6
      7                   7
    10                 10

I would like the following values returned

      4
      8
      9
   

I currently have the following formula

whileprintingrecord;
numbervar Hole := {table.End_num} +1;
while Hole < (next({table.Start_num} -1) Do
(
Hole := Hole +1;
);
Hole


Any guidance would be appreciated, seems like maybe I need to store the values in an array then print them in my report.  I am still getting the hang of crystal syntax.


Edited by karad - 11 Mar 2010 at 1:56pm

Not my area of comfort but here is a similar post but dealing with dates that might give you help...