Thats perfect, exactly what I needed, thanks Jeff

Lynn

Great !!!! Thats exactly what I needed to do - I can see where I was going wrong now. Many thanks for your help!

Matt

Thanks Lynn

Relevant field defs for the table;

JobNo - dec (6,0)

Status - Char (2)

TransDate - Datetime

RecordID - Identity (BigInt)

Job         Status        TransDate     RecordID

1234       AB              01/07/07      1

1234       AB              02/07/07      2

1234       AB              03/07/07      3

1234       AB              03/07/07      4

1234       AB             ...

I had a similar problem and eventually found a SP on the web which I extracted into a Job (agent). It's interactive but it does sort out the immediate issue;

/*

       ...