note brap How about something along the lines of: <code> select name from mytable where acc = '12345' and year = (select max(year) from mytable where year in( $year, $year+1 )) </code> The syntax is probably dependent on your database, though. 849572 849572