Hi Dave, and thanks again...

I tried this but since it groups by revisionnum, it simply gave me one row for each partnum/revisionnum/effectivedate. I'm actually looking for the very LAST...

Hi Dave, and thanks for taking the time to reply!

I ran that query and it returned 0 rows. Argh!