Well I wrote a really great response but wasn't logged in because I opened the link from email and lost the response when I hit submit and was asked to log on and it's been so long since I have run into this conundrum that I didn't select all - copy, so it's gone. Here's the gist.
I'm using it to remove duplicates from a table before making the field unique.
Nice ideas from Dan, many thanks!
For the record QB does not offer native a solution to filter a Summary report using the Summary field generate by the report. I will submit a user request to the page.