# Thread: Weighted Average Maturity (Access 2003)

1. ## Weighted Average Maturity (Access 2003)

I need to calculate the weighted average maturity across a portfolio of over 600,000 accounts. I know how to calculate the maturity it both days and fractional years. A simple average is easy using the built-in function. However, I need the weighted average and it's been too many years since I did that in school.

Any suggestions?

Thank you for all your help.

Nancy

2. ## Re: Weighted Average Maturity (Access 2003)

The expression for weighted average maturity is
<code>
Sum([Amount]*[Maturity])/Sum([Amount])
</code>
where Amount is the value the account. In a query you'd use it in a calculated column:
<code>
WAM: Sum([Amount]*[Maturity])/Sum([Amount])
</code>
and on a form or report in the Control Source of a text box:
<code>
=Sum([Amount]*[Maturity])/Sum([Amount])</code>

3. ## Re: Weighted Average Maturity (Access 2003)

Thanks, Hans. I had the divisor as the Maturity. I knew it had to be something dumb like that.

I appreciate your quick response.

Nancy

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•