Search results

I am currently working on compiling all of my worksheets into a single sheet, "sheet 1" format. Once I have completed that and put it into the database as sheet 1, do I simply run each of your append queries in the labeled order? Also would I build my qryMain the same as the way you did...

Sounds like some stuff that is way out of my league. So if I wanted to use the table structures you have created and manually upload the data and values from the multiple spreadsheets I have would that be possible. Or would I need to recreate your cleaned up version of our upload sheet in...

Wow, so I really was way off huh. Thanks for the restructuring. For our comparison and analysis the discounts are already applied to the gross and net numbers so really will not need to be evaluated or extracted through the database. As far as you "migrating" the data from the...

I believe I have created a new query with the proper tables and relationships necessary. However when I run the query the only "vessel name" is seems to be pulling up data for is "Vicksburg". It is summing correctly and giving the right number but if i try any other vessel name that I know has...

In regards to the above, for the purpose of what I am currently trying to deliver all calculations, and data entry is done on the excel sheet. Due to my novice understanding of access we are not aiming that high yet as to eliminate the excel entry sheets for co-workers. I would just like to...

Hi jzwp, I feel that I have the database in a pretty stable structure thanks to all your help and would now like to begin to address my original problem. Summing I would like to start setting up some queries that my co-workers can use to run useful searches. The first one I would like to be...

Maybe I should have just shown you this from the beginning. Attached is the excel sheet that my coworkers upload their data into. When they issue a new policy they take a blank upload sheet and enter their new data into it then send me that sheet. The purpose of this database is to contain...

Thank you for the response and the upload. I have made the adjustments to my database to reflect what you have uploaded. As far as the policy details table and discount table go I made some changes. Since the discounts are the same across a single policy I have set it up to reflect that...

For the purposes of this database, whether or not an owner still technically owns a vessel is not really of concern. For that particular policy year that we insure them they own the vessel and that is the data we are trying to capture. I guess in a way we will be using the data to...

yes hopefully with all your help, which has been very informative, we will have a polished system that we can use for several years. a vessel typically will not move from one policy to another or move from one owner to another. things remain relatively stable for the policy period which is...

i am making it as if the vessels do not move. we are just trying to track our data from 2010 and forward and most vessels are stationary for 5+ years, and hopefully by then we will have a more polished system to track this, perhaps through a third party.

thanks again that stuff looks great, i am going to start implementing it shortly. an owner can have multiple policy numbers, as they can own many vessels in different parts of the world which are completely different policies we can write. a single policy number will only have a single...

jzwp, thanks so much for this help and guidance. I am going to make the changes you have mentioned as well as reaching normalization and simplification of the tables and their structures. As far as the products, types, and policies go let me try and explain this better. An owner is the...

jzwp, thank you very much for your time and help. I am not exactly sure what this means: (FROM Vessel, Products INNER JOIN [Policy Details] ON Products.ProductID = [Policy Details].ProductID) Is this something I should be typing in manually somewhere? or is this just the breakdown of what i...

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

themurph, thank you very much this is very useful and simple to implement. from a form or report standpoint do i just simply select my newly revised queries with the parameters and create them from that or can i use parameters specifically within forms for the users to choose? again any help...

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

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

Attached below is my database so far. There is very limited data in it as I plan on only using 2011 data which we have not fully finalized. The data in there currently is arbitrary and just space fillers to test out my database as i built it.

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