If I understand that last one correctly you only want to show the max rownumber (so only once)?
Sometimes the Programmer Sometimes the DBA Mazz1
Forum Rules