Calculation

[Sam]

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

 

[Jeff Boyce]

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.