Comparing tables

[sislman]

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 (each Table has a Policy Number Column).

Im new to Access and do not know how to go about this.

Any help would be appreciated.

Regards

 

[mea00jmf]

You need to create a query with the Sales and Claims table linked by the policy number.

You can then select which fields to show as the result of your query. The loss factor can be calculated as an expression in the query.

If you are not sure how to accomplish this then have a look in the help text.

 

[neileg]

You might want to create a totals query on your claims table first as I assume you may have more than one claim per policy. Join this to your sales table in another query.

You need to use a left join (return all the records in sales and those from claims that match) because there may well be policies sold with no claims.

 

[sislman]

Thank guys

Regards