This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!
Solved
Calculate APY in Access
Posted on 2004-08-31
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
Is there a way to perform this calculation in access? Thank you
=((1+RATE/100)^(TRUNC(TERM
Is there a way to perform this calculation in access? Thank you
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
I think your problem is with the TRUNC function.
Try changing it to INT, (look up help on INT and FIX to see which function is better for you. Both drop the decimals, but handle negative numbers differently.)
=((1+RATE/100)^(INT(TERM/1
Try changing it to INT, (look up help on INT and FIX to see which function is better for you. Both drop the decimals, but handle negative numbers differently.)
=((1+RATE/100)^(INT(TERM/1
You can use this expression in a query:
((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.
((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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month9 days, 23 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.