Hi all,
I have been creating a database for my company to capture "open exposure" for oil rigs we insure across our entire portfolio. I have created the tables and set up the database (attached below), but our goal is to be able to compare and analyze different data points across the portfolio (i.e. total exposure, location, coverage type, etc.)
Now that I have the database set up and have began to fill it with our data my goal is to create queries or forms that my co-workers can use to extract various aggregations of information. I have been able to figure out how to set the criteria that they type in (ie. vessel name, location, etc.) but when I run my query, (the one in particular is to select a vessel by name "Richmond") and then display the sum of the exposure for that vessel, "Richmond". Now I know that there are only 6 instances of Richmond in my data so I assumed it would "sum" those 6 exposures but it seems to be adding up every single vessel's exposure.
Ultimately, what we would like to be able to do is have the users select/type in different criteria and then run a query on said criteria such as "Total Exposure” for all "Vessels" in "Africa".
I am a novice access user but have been finding enough information from various forums and tutorials, especially this one, and think I just need a push in the right direction to get to where I need to be.
Thanks in advance for any advice and help as it is much appreciated.
I have been creating a database for my company to capture "open exposure" for oil rigs we insure across our entire portfolio. I have created the tables and set up the database (attached below), but our goal is to be able to compare and analyze different data points across the portfolio (i.e. total exposure, location, coverage type, etc.)
Now that I have the database set up and have began to fill it with our data my goal is to create queries or forms that my co-workers can use to extract various aggregations of information. I have been able to figure out how to set the criteria that they type in (ie. vessel name, location, etc.) but when I run my query, (the one in particular is to select a vessel by name "Richmond") and then display the sum of the exposure for that vessel, "Richmond". Now I know that there are only 6 instances of Richmond in my data so I assumed it would "sum" those 6 exposures but it seems to be adding up every single vessel's exposure.
Ultimately, what we would like to be able to do is have the users select/type in different criteria and then run a query on said criteria such as "Total Exposure” for all "Vessels" in "Africa".
I am a novice access user but have been finding enough information from various forums and tutorials, especially this one, and think I just need a push in the right direction to get to where I need to be.
Thanks in advance for any advice and help as it is much appreciated.