Here is one way:
Thank you DBlank. I think the syntax of your example got screwed up, but you sent me in the right direction and the report is working well.