Calculation

Hello All

I need to calculate the average weighted interest rate for a report. I know
how to calculate this manually (using a calculator) however I cannot manage
to have MS Access calculate it. The formula is:-

Loan Amount
-------------------------------------------- (==== Divided By)
Total Funds Disbursed X Interest Rate

Can anyone assist?? Do I place the formula in a query or Report???

Thanks

Sam

Where are you getting the factors in your equation? Are they data stored in
a table?

You've posted in a "queries" newsgroup, so I'll guess that you are using a
query to retrieve these values (this is only a guess -- you mentioned
"reports", too).

You could create a new field in the query by adding in something like:

[Loan Amount]/([Total Funds Dispersed] * [Interest Rate])

Note that if your field names have spaces, you'll need to bracket them with
square brackets.

If those aren't the actual field names, use the real ones.

--
Regards

Jeff Boyce
Office/Access MVP


"Sam" wrote in message
...
Hello All

I need to calculate the average weighted interest rate for a report. I
know
how to calculate this manually (using a calculator) however I cannot
manage
to have MS Access calculate it. The formula is:-

Loan Amount
-------------------------------------------- (==== Divided By)
Total Funds Disbursed X Interest Rate

Can anyone assist?? Do I place the formula in a query or Report???

Thanks