And after a few more hours on the massage table we get the final product:

SELECT Badge_Num, RecordNum

FROM (SELECT...

I'm using view designer (New View) in management studio

I'm used to it not likeing my ORDER BYs ... but it does remember them and use them.

WOW! ... took me a few hours to understand what this is doing ...

and a couple more to convert it to the actual use ... but man ... this...