Search results

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

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