Search results

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Hi plog, Thanks again for you help. I am quite a noob and apologize for the poor file upload. Attached is a cleaned up one, yes the query I'm looking at is the 'GenerateFunidngPlanData"

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Anyone out there who could contribute? Help me, Obi-Wan Kenobi. You're my only hope.....

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest plog, I attached the file. I tried the EndBalance approach. When I include the dlookup statement in the startbalance expression for the query, the whole things crashes (literally). Any help is appreciated.

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Could DSum work with this?

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Essentially a cumulative sum with additional data. I found this link: http://itdeveloperzone.blogspot.ca/2011/03/cumulative-sum-in-sql-server.html But I am a noob and can barely get by with the existing SQL...

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest The first row is showing the right data for startbalance, annualcontribution and interestincome. The second row should show: 488,098 as the next start balance (the sum of 404,585 + 61,740 +,21,773). This is...

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Weird, I embdded the image into the post above. The link is http://s9.postimage.org/4xp6cg5zi/Untitled2.jpg

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Hi Plog, Thanks again for your help. I posted the sql statement and a screen shot, is this sufficient?

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Also, I was using an if statement to determine if the startingbalance record was the first row or not.

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Yes, it is the basis. The SQL argument is the following: SELECT AnalysisYears.StudyYears, [Funding Plan Ideal Balances].UnadjustedIdealBalance, [Funding Plan Ideal Balances].InflationAdjustedIdealBalance...

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest

Re: Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Ah yes, there is no order, my apologies. Rows are "technically" ordered by year, the query looks for years and returns the range in the column "StudyYears", and the query data is sorted by this column, increasing.

Add Three Previous Row Value Together to Make Next Row Value -Balance & Interest Calc Howdy All, I have three columns, StartingBalance, AnnualContribution, and InterestIncome. I would like to build a query that for the first row, uses a previously defined elsewhere starting balance, annual...

Using Allen Browne site, I see I should first define each variable prior to any iif statements. I started with the following: [PriorAnnualContribution], (SELECT TOP 1 Dupe.PriorAnnualContribution FROM PriorAnnualContribution As Dupe WhereDue.StudyYears = GenerateFundingPlanData.StudyYears But...

How would one convert this into a subquery? DLookUp("[AnnualContribution]+[InterestIncome]+[StartBalance]","GenerateFundingPlanData","[StudyYears]=" & [StudyYears]-1) As I just want to add the three values from the previous record together? I used an iif statement to judge if it was the first...

After reading Allen Brown's site, I should be using a subquery. I'm quite the noob, but is this an easy subquery to construct?

Trying it now...thanks

Hi All, Can anyone help me clean up my query so that it doesn't crash access and cause the CPU usage to sky rocket? I want to simply add together values from a previous line, and it worked fine for one column (though slow) using the dlookup feature. When I did it for another column with...

Thanks so much for your help! I replaced all instances with intMaxYear, though when I try a start year of 2012 and an end year of 2042, I get zero entries. If I comment out the following: If (rs!OriginalYearBuilt >= Me.tbFromYear) And (rs!OriginalYearBuilt < intMaxYear) Then along with the...

I made the replacement in the If statement as below: While Not (rs.EOF) 'whilst not End Of File If (rs!OriginalYearBuilt >= Me.tbFromYear) And (rs!OriginalYearBuilt < DMax("[OriginalYearBuilt] + [LifeExpectancy]", "[ReserveItems]")) Then ' OYB starts during the specified period for...