I'm going to have to totally re-write it anyway because of other issues. I'll take a look at this when I get back to it.

Thanks,

Michelle



>You're right, in this case sorting won't obviously help you. However, a cursor still might make your life easier:

LOCAL ;
>	lnLowestValue, ;
>	lnLowestRow, ;
>	lnNewValue
>
>* Initialize the cursor:
>CREATE CURSOR iTest ;
>	(iValue I)
>
>FOR lnIx = 1 TO 6 STEP 1
>	INSERT INTO iTest ;
>		(iValue) ;
>		VALUES ;
>			(lnIx)
>
>ENDFOR
>
>* Change the values:
>lnLowestValue = 1
>lnLowestRow = 3
>
>REPLACE ALL ;
>	iTest.iValue WITH IIF(RECNO("iTest") < lnLowestRow, ;
>		RECNO("iTest") + (RECCOUNT("iTest") - lnLowestRow) + lnLowestValue, ;
>		lnLowestValue + (RECNO("iTest") - lnLowestRow)) ;
>	IN iTest