Finding the Average Amount of Items (1 Viewer)

Hi,

I work in the Insurance Industry and I am having a hard time trying to find the formula for finding the answer to the below issue I am having.

In a table I have 4 columns:
1st: Total # of Claims (Claim Count)
2nd: Total # of Items (Item Count)
3rd: Item % of Claim Count
4th: Average # of Items per Claim (This is the number which I am trying to get)

Is there a formula which could give me the "Average # of Items per Claim"?

Thank you in advance for your help!

Isn't that just items/claims

Brian

Hello BWheat35, This sounds more like a calculated value and tables are not the best place to store them.. You might want to read over Calculated Field in Access, This would be more sort of a Query information.. With a query it is easy to display the information that you need..

Also on a side note best to stick to a good naming convention.. some pointers would be avoiding spaces in field names, avoiding use of special characters...

* Total # of Claims can be ClaimCount
* Total # of Items can be ItemCount
* Item % of Claim Count can be ItemToClaimPercent

I must learn to read more carefully, with words like total # of etc I thought that this was a query.

Brian