Search results

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.

hi jzwp, hope all is going well. I have made some adjustments to the format of your "sheet1" which is what I am using to import my data from excel to the database. Per my bosses request I have added net premium and net rates to "sheet1". Also all rates will be manually entered and are not...

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

Great, I can't thank you enough for all your help along the way. Have a great weekend.

I made the necessary adjustments to the tables regarding the gross rates as well as the changes to the qry9AppendPolicyVesselLocationProductDetail to include the gross rate field coming from sheet1 and its corresponding field. In regards to the duplicate data that you highlighted, I contacted...

Issue 1: I went through most of the spreadsheets of data that we have and I believe that that one sheet I happened to be using as my first sheet to enter is the only one with a calculated gross rate dependent of the vessel type. All of the other sheets have manually entered gross rates. I am...