I have been creating a database for my company to capture and track our portfolio of open insurance policies on a multitude of "Mobile Oil Rigs". Every policy has its own policy number/ID but there can be multiple policies per "vessel".
What I would like to be able to do is to run a query by "Vessel Name" to sum the open exposure under all the policies for a given vessel. Is there something I can put in the "criteria" section to say ifvesselname "Rotterdam" then have a sum for exposure?
I feel like there is a simple solution to this query, I am just not sure how to get there. Any help is much appreciated. If more details or information regarding the database is needed I will gladly provide in a follow up post.
Thanks in advance for your time and consideration.
What I would like to be able to do is to run a query by "Vessel Name" to sum the open exposure under all the policies for a given vessel. Is there something I can put in the "criteria" section to say ifvesselname "Rotterdam" then have a sum for exposure?
I feel like there is a simple solution to this query, I am just not sure how to get there. Any help is much appreciated. If more details or information regarding the database is needed I will gladly provide in a follow up post.
Thanks in advance for your time and consideration.