Search results

  1. A

    sum and show parts of sum

    I was wondering if it is possible to do a sum query but show the parts of the sum. For example, my database tracks insurance policies on oil rigs, and a single rig can have multiple policies on it. Currently I am summing all the open policies on a particular rig by typing in a rig name and...
  2. A

    Criteria question

    Hi all, I am looking to create a criteria parameter that would allow me to run a query and draw results of a few different products. I have been using the statement " Like [Please enter product name] & "*" " I was wondering if it is possible to use a join such as "or" to do that twice. So...
  3. A

    summing trouble

    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...
  4. A

    General Form Question

    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 (poorly at best), but our goal is to be able to compare and analyze different data points across the portfolio...
  5. A

    Calculating Sums in Query

    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...
  6. A

    Calculating Sums in Form

    http: //i53.tinypic.com/5b8x9u.jpg (remove the space between the http: //...) Hi everyone, I have built a database with 5 tables to track and record oil rig vessels, their policies, owners, and type of products. What I am trying to calculate is the total "exposure" that an owner has. A...
  7. A

    General Table and Key Setup Help Requested

    I have not created a database from the ground up in a few years but am familiar with using access and the general methods. What I am trying to create is a database with data on a number of "Owner/Clients", all the "Vessels" each client owns, the "Vessel" details such as type of vessel, price...
Back
Top Bottom