Hello, I have an access table that has these two fiedls - TERM and RATE. To calculate the APY, currently I have to export this table to excel and run this formula:
=((1+RATE/100)^(TRUNC(TERM/12))*(1+(RATE/100*(TERM-TRUNC(TERM/12)*12))^(12/TERM)-1. Then, I have to import the excel file back into access and perform the rest of the queries.
Is there a way to perform this calculation in access? Thank you
((1+[RATE]/100)^(Fix([TERM
In other words, you can write a query like this:
SELECT *, ((1+[RATE]/100)^(Fix([TERM
This will return all of the fields in your table, plus a calculated field called APY with the results of your calculation.