Results 1 to 2 of 2
  1. #1
    dpgreen is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    1

    Using Financial Formulas from Excel on query results in Access

    Hi Everyone,

    Let me just begin by saying I am a complete idiot when it comes to Access. The first time I used it was about 4 weeks ago and I've been self teaching myself the software (with little success) for that time. I've built a relatively nice (simple)...(Very simple)... database which does most of what i require but I did not use any coding nor have any knowledge of coding so if you know the answer to my question and it requires coding please can you explain it to me as you would a child. Novice doesn't begin to explain my level here.

    Anyway onto the issue. As it stands I have a query that includes several columns, one of those columns shows returns on investment as a percentage. I need to figure out the annualised returns on investment using the following excel formula



    {=PRODUCT(1+B1:B24)-1^(12/24)-1}

    This formula gathers the percentages for the last two years then provides an annualised amount.

    I'm just wondering whether this is possible to apply to the query so that when I open the query it can provide me with the 2 year annualised statistics.

    If I've done a poor job of explaining my issue my apologies because I really don't know how to describe my problem and I'm fairly sure I solution doesn't exist but if anyone has any idea they would be greatly appreciated.

    Many thanks.

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Till some one comes along, just check out if below gives some guidelines :

    http://www.pcreview.co.uk/forums/acc...-t3485250.html

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-30-2012, 05:10 PM
  2. Financial Query
    By Luke in forum Queries
    Replies: 8
    Last Post: 06-30-2011, 12:33 PM
  3. Replies: 9
    Last Post: 06-26-2011, 09:14 PM
  4. Exporting Query Results to an existing Excel Workbook
    By Dnphm in forum Import/Export Data
    Replies: 3
    Last Post: 07-13-2010, 11:40 AM
  5. Access to Excel: Financial Forecasting Tool
    By BLUE_CHIP in forum Import/Export Data
    Replies: 2
    Last Post: 06-19-2010, 01:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums