Recent content by jrub

Hi Everyone! I hoping someone can provide some info as to a solution to this problem. I need to add two previous record fields together in a query. I have attached a picture to help illustrate. The "StudyYears" filed is the primary key of the table the data is being pulled from. The zero's...

Hi All, Is it possible for an update query to simply replace all the data in a table's field with the results from a query? For example, I have Table A with the field Years. This table performs various calculations within based on the field Years. I would like an update query that simply...

Ok, what if I include an iif statement within the dsum to place the correct value in the first record, and begin the running sum in record number two? It would go like this I imagine: RunningBalance...

Although, is there a way to set the first record a specific value, and then have the Dsum perform a running sum from record 2 and onward (taking into account record 1's set value) ?

I see your point. The interest is calculated using a mid-year interest formula, which I don't think access has. But Im looking into other ways to compute it so it doesn't require other "within the same record" values.

Thats kind of my intention . The running balance calculates from the previous record. The interest is calculated from the result of the running balance for the current record. The very first record's running balance and interest record's are seeded with a value set by the user, where the...

Can anyone out there help ? I mangled the following code together: RunningBalance: IIf([StudyYears]=[ReserveParameters]![StartingBalanceYear],[ReserveParameters]![StartingBalance],Val(Nz((DSum("[Interest]+[Contribution]+[Inflation_Adjusted_Expenditures]","Query1","StudyYears <=" &...

Thanks for the reply. I am trying to have the first year (2013) Balance be defined elsewhere and then have the running sum incorporate the "defined elsewhere" as the first value of the running sum. I tried using a modified dsum statement with Nz around the Interest and Contribution fields to...

I'm trying to get a running sum working with two calculated fields. The Dsum is nested within an IIF statement, to detect if it's the first starting year and provide the initial balance value. In subsequent years, I would like to have a sum of the previous Interest and previous Contribution...

Ah, this was the money shot: Link That fixed some of the text recorded, but failed again when it came to another comment that used " and ". So I replaced them with ( and ) until I figure out more.

HI All, Trying to get a a fancy query going though some VBA code.....everything worked, until someone put a pile of text in a comment box in one of the records, which forms parts of the query search. When I run the below code, I get error 3075: Syntax Error Missing Operator. Option Compare...

Yes, exactly that. Any ideas?

I think this has morphed into another thread, which I started below: http://www.access-programmers.co.uk/forums/showthread.php?t=242008

Hi Everyone, From the image below, I managed to get calculated filed data summed and added to the next row. What I can't get done, is adding the previous "RunningBalance2" data to the next row as well. When I included the field "RunningBalance2" to the query statement, Access won't even let me...

Well, I am trying to put together a way to change the interest rates, and have the balance automatically adjust to match other parameters. At first, it may sound easier in excel, though due to the fact the other parameters are summations of a large amount of data needing access to calculate, I...