Thanks, I think this works, but not sure of how it would work on a report with tens of thousands of lines....

Something tells me there is a much easier automated solution out there....if I could just find it