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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
XIRR- Reference thread 705-1740838
This works great and !! I never thought access query engine will cause the problem....Access is not perfect :( I don't know how to make table query for Union query. So I made another query of Union query. Again thanks, you made my week.- accessdb
- Post #18
- Forum: Microsoft: Access Modules (VBA Coding)
-
XIRR- Reference thread 705-1740838
I have been trying to solve the problem with the query for few days. This is way over my head...... [qryXIRRCalculation] SELECT qryXIRRUnion.FundName, AccessXIRR("qryXIRRUnion","Amount","XIRRDate","FundName",[FundName],True,0.2) AS XIRR FROM qryXIRRUnion GROUP BY qryXIRRUnion.FundName...- accessdb
- Post #16
- Forum: Microsoft: Access Modules (VBA Coding)
