Hi all again,
I'm doing some computations on a records in a table using the SCAN ... ENDSCAN. I have a variable (var1) which stores the compound number (1, 2, 3,..) and var2 (1, 2, 3,..) which stores the house number. Var2 is incremented by one from the previous record if the compound is the same otherwise var2 starts from one again. I was wondering if there's a function in VFP6 that can lag values (something like the LAG() function in SAS!). Or how do I go about this? I want my code to "see" the previous value of compound (var1) and/or house (var2).

Thanks in advance guys.
Richard.