• Whoops sorry about that.

    I used an old create table script and didnt finish it properly.

    Thanks for the advice. I think I used MIN, MAX and then grabbed the other ID that isnt in the min OR MAX temporaty tables.

    Debbie