Search results

Hi, The Cover Options on the X Cars Scheme are: - £200 £400 £600 If J Bloggs has Claimed for £250 then it is most likely he Purchased the £400 Option. He couldn't have purchased the £200 Option as his claim exceeds this limit. What I am trying to do here is allocate the most likely Excess...

Hi, I the following table named 'Claims' which contains some claims information. [Scheme] [Claimant] [Claimed Amount] [Excess Banding] X Cars J Smith £150 X Cars J Bloggs £250 Each Scheme has various levels of cover available which are defined in the following table named...

Hi, DB1 is received from our Agents and contains 200k+ lines of data. DB2 is approx. 20 lines of data showing highlevel data for each scheme we run i.e. Policy Number, Scheme Name & Inception Date. I need to produce data based upon Scheme Inception Dates which are not shown in DB1. So I...

Hi, I have two databases. DB1 - Is main repository of data DB2 - Contains highlevel data i.e. Scheme Name, Inception Date (1 line of data for each of our Travel schemes) I would like to write a query that will enable me to do the following: - 1) List only lines of data from DB1 that match...

Hi, I see what you mean, however, the reports that I will be running from the query will be most counting records Iso I dont think it really matters what policy number I choose to show. Regards Matt

Hi, Basically I want to show each policy number once, not totally disgard the data if there is a duplicate. I just dont want to show rows with duplicate policy numbers. Regards Matt

Hi, I have a query with in excess of 20 fields. One of the fields is [POLICY NUMBER]. I want to use DISTINCT to only show rows of data where the Policy number is unique. If I put DISTINCT after SELECT the query will only include results where the combination of values from all the fields are...

Hi, I have a report which contains the following textboxes which contain Runningsum (all over) calculations: [cum.earned prm] / [cum.net prm] / [% of cum.earned of cum. net] I need to calculate [cum.earned prm] as a % of [cum.net prm] with the result appearing in [% of cum.earned of cum.net]...

Hi, It doesnt seem to mater what format it's put in I tried putting it in Date/Time but it still sorts in this order : Apr 06, Feb 06, Jan 06, Jul 06, Jun 06. Regards

Ok thanks, I managed to do this fine, however, when I come to sort by the new date column it will not sort in the correct order. From some reason Apr 06 is coming before Dec 05 and Jan 06? Any ideas? Regards

Hi, If I have a date that is formatted like this 01/01/2006, however do I write a query that shows the date as follows Jan 2006. Thanks Regards

Hi, I have table with the following columns: [scheme] , [date of sale] , [year of account] I want to write a query that does the following. If [scheme name]="CARS" and [date of sale] falls between 01/12/2005 and 30/11/2006, show "2005" in [year of account] Thanks for yur help Regards

Hi, I have a table with in excess of 50k lines of data. I would like to sumarise this data in a report based upon a query. I have written the query which cuts the data down to about 4k lines and I want to summarise the data under the following headings: "Date Sold", "Total Premium" , "Earned...

Hi, I used the Group By clause however I have to Group by at least 10 Fields or less if i have less than 10 fields in Query. How can I just Group by 1 field? Regards

Hi, I tried what you suggested but it didnt seem to work. If I let Access choose a Primary key it just gives each line a different number, therefore, if I have two lines of data with the same Policy ID they are numbered differently. I tried setting Policy ID as the Unique Idenfier however it...

Ok cool thanks i'l give it a go. Kind regards

Hi, Im very new to MS Access so bear with me. I have a table containing travel claims data. In some instances there are multiple claims attached to certain policy numbers. Currently the Table has a seperate line of data for each and every claim. What I need to do is to ensure that there is...

Thank guys Regards

Hello, I have two tables: - 1) Sales data 2) Claims data I want to anaylse Premium (contained in the Sales Data Table) against Claims (contained in the Claims Data Table). The result I want to achieve is to show a loss ratio (Premium / Claims as a %). I need to show this on a per policy basis...