If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Calculation
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Variable for holding a calculation for a text box | patentinv | General Discussion | 3 | October 9th, 2005 01:23 PM |
Calculation Setting in Excel | Stuart Bisset | General Discussion | 0 | June 17th, 2005 09:54 AM |
calculation based on a calculated value in a report | steely via AccessMonster.com | New Users | 2 | June 3rd, 2005 08:06 PM |
How do I use a rounded calculation result in another calculation? | vnsrod2000 | Worksheet Functions | 1 | January 26th, 2005 10:11 PM |
How do I use a rounded calculation result in another calculation? | vnsrod2000 | Worksheet Functions | 1 | January 26th, 2005 09:36 PM |