Recent content by aml5171

sorry i am calling them vesselname in the database

it is the older version of access, i think its 2003-07 i guess. sorry i am no longer at my work computer so can't check to remember the years

I do not even know where to begin. I have 9 append queries. attached is my database if you would like to take a look at it. I figured showing the parts of the sum was an easy expression or adjustment to my query.

I'm sorry if I explained it unclearly, but no values are being entered via the query. The way I have the database set up is with a master excel sheet that contains all my companies data that is regularly updated, which I then import from excel as "sheet1" into the database and run append...

For now I just would like to have this show in a query. I have not started creating forms or reports into my database yet. Do they provide any significant advantage to the user besides an aesthetic one? It is not that the query I am currently using is not providing the "desired" results, I...

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

I definitely appreciate you keeping the queries less complex and less overwhelming. I am not receiving an error, just no records being appended.

sorry, it is not really a type of deductible. it is simply just another metric that is a possibility for policies. does it need to be individually joined to something in particular? also, i did not know that i needed to delete the records that were already in there before running the append...

Hi jzwp, Everything was working great with the database and the queries I had been making and running were meeting our needs. BUT, as you said, I have now been asked to “do other things” with the database. Instead of Inception Year, now we want to have Inception Date and Expiry Date. I...

I am trying to use this as my sql statement; INSERT INTO tblPolicyVesselLocationProducts ( fkPolicyVesselLocationID, fkProductID, longDeductible, currInsuredAMT, currROW, currSL, LineSize, dblGrossRate, dblGrossPremium, dblNetPremium ) SELECT DISTINCT...

I am sorry but I am not really sure how to interpret that stuff. I understand the INSERT INTO part and added the necessary field1, field2, etc. In regards to the rest, The “SELECT DISTINCT…” stuff, is that an SQL statement I should be typing in, and if so where.

I completely understand your points and perspective in regards to the database and understanding their requirements. However, most of the office is located in London, whereas I am in New York so sitting down and discussing the intricacies of the discounts is very difficult to do as they are...

Unfortunately I do not really know all the answers to those questions. I am not very involved with the underwriting side of these insurance policies. I just know that there are many different types of discounts and every single policy has them applied differently. I believe the discounts are...

Ok, from looking at my original excel data sheets, the net premium is dependent on the discounts which I have chosen to not include due to its variability and complexity. I beleive I need to add dblGrossPremium, and dblNetPremium to tblPolicyVesselLocationProducts. For net rates I would want...

understood, but these calculations are already performed within the excel sheets which i am "cleaning" up and using as my upload sheet. I assumed it would be easier to tweak the appends to incorporate these added values rather then run the formulas again through access.