Thank you very much. I thought there might be an easy way with the max function, but it looks like I need to use a different function...so will go and...

I am confronting the same problem and don't really know how to solve this. I think you can use trigger queries, but haven't really looked too far into this.

Thank you ever so much :0)

thats brilliant thanks. do you happen to know the VBA to trigger this? I have:

Dim cmd As ADODB.Command

Set cmd = New ADODB.Command

Set cmd.ActiveConnection = CurrentProject.AccessConnection

cmd.CommandText = strSQLFinal

which executes some sql...

brilliant! thank you

The plot thickens...sorry i didn't want to make to too complicated to begin with but what if i have this table

PersonId, Value, AltValue

1, NULL, 6

1, NULL, 6

1, NULL, NULL

1, 6,...

Sorry i should have been more specific - i was trying to break the problem down into the part i was stuck with. this is actually the result table i...