Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sanjay_S

    XIRR- Reference thread 705-1740838

    MajP, So far no incorrect solutions or no solutions, where the cash flows are with the right signs. I am also checking this frequently against excel workings, and will bring any anomalies to your notice. Thank you once again for the excellent and committed assist in solving this problem. Sanjay
  2. Sanjay_S

    XIRR- Reference thread 705-1740838

    MajP, Apologies for the delay in posting this. I have worked with your XIRR module across a few months, and have validated the workings compared with the earlier excel model I was using. It is accurate down to 0.1%. Also, saw your last post above just last week, and the tip there enabled me to...
  3. Sanjay_S

    XIRR- Reference thread 705-1740838

    MajP, Please ignore earlier message- figured out the problem. All cash flows in the [Live Amount] field cannot have the same sign- some are inflows, and some outflows. I need to build in a separate cash flow field to handle that, and then,I think the function will work fine. Thanks a million...
  4. Sanjay_S

    XIRR- Reference thread 705-1740838

    MajP, Checked out the revised code, and modified the last date to function CurrentMonth(), which is the formula I had given in my previous post...i.e., considering we are in Sept, the last date has to be the last working date in Aug, not July, which is what your date(i-1) function gives. The...
  5. Sanjay_S

    XIRR- Reference thread 705-1740838

    MajP, Thanks a million for the help! 76% sounds about right for the data that we have. Let me try and use the new code on the actual database and report back to you on the speed and accuracy. I hope to do this by tomorrow. Sanjay
  6. Sanjay_S

    XIRR- Reference thread 705-1740838

    MajP, Apologies for the late revert. I tried the method you had suggested, but I still cannot get the excel reference to work. No matter, as the the other method works just fine. Thank you once again. A different query though, and kindly excuse my rudimentary VBA knowledge. In the attached...
  7. Sanjay_S

    XIRR- Reference thread 705-1740838

    MajP, Thank you once again for your interest- I did think of trying out your other code for XIRR, and did get a result out of it. I had to modify the line: "AccessXIRR = MyXIRR(Payments, Dates, GuessRate)" to "AccessXIRR = Format(Round(MyXIRR(Payments, Dates, GuessRate), 4), "Percent")" to get...
  8. Sanjay_S

    XIRR- Reference thread 705-1740838

    Hi MajP, You were the one who wrote this code, so thank you for your interest. I did notice that I would have to do the field parameters in the query to match those in the table. So I modified the query as : SELECT tblPayees.PayeeID, AccessXIRR("TblPayees","[Payment Value]","[Payment...
  9. Sanjay_S

    XIRR- Reference thread 705-1740838

    I had tried to use the first part of the XIRR code (calling the function from excel) given by MajP in the above thread, but I get an error "Run Time Error 3061 Too Few Parameters. Expected 2, and the debug stops at the line :"Set rs = CurrentDb.OpenRecordset(strSql)". I have put the table...

Part and Inventory Search

Back
Top