• Yeah, an example would help. Franks example would work if the id field is sequential. If you delete a couple rows then the code wouldn't work.

    Clive Strong

    sqlsrvr_dba@hotmail.com