Thank you so much Madalyn for the recommendation.  It was really helpful!

I am creating a project report listing current projects.  I am having trouble creating a query which lists the weighted ranking based of the data displayed in the 'Priority' and 'Benefit & Effort Score' columns.The Priority allowed values are High, Medium, and Low. The Benefit & Effort Score value r...