I have a database of all blood drives promoted by our organization. To look at a particular drive I query the date of that drive, then create a report based upon that query. For this post I will be dealing with two fields in the query: [Tag], and [Successful Donation], both are short text format. [Tag] indicates a regular blood donation with a "B", or a power red donation with a "P." [Successful Donation] indicates the result of attempt: Yes = blood was drawn, CG = could not give, C = Canceled, and NS = No show. I need an expression in a calculated field in the report that yields the count of the "Power Red donors" that were successful in their donation. In other words count the "P's" in the [Tag] column IF there is a corresponding "Yes" in [Successful Donation] column. Thank you for your help.