Search results

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...

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...

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...

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...

Hi All, Is it possible to program a make table query to include a calculated filed in the final table? By include, I mean include the calculation, not the static value? For example, I have a table with Rate, Interest and Total and other data. I would like the make table query to make the...

Hi Everyone, I have a dsum to summ all previous values. It's being used in a continuous form with only max 30 record. If it's 2013, I want the first record to be 1000, and the rest of the following records be the a running sum. I get a #Type! error in the first record and a #Error in the...

Hi Everyone, I'm looking for some help with referring to a previous record in a form and performing calculations with that value. I've uploaded a sample DB to better understand what I refer to. In the form, a user can adjust the "Percent" cell percentage to what they like. The neighboring...

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...

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...

Hi All, Very new, but I thought I would post here as I imagine a solution would be a macro that one passes variables to... Hi All, I am a huge NOOB here, so please bare with me I have Query1 which I would like to add a record set called Expenditure Years to. The Expenditure Years are...

Hi All, I am a huge NOOB here, so please bare with me ;) First post and Im really hoping that someone can help me out. I have Query1 which I would like to add a record set called Expenditure Years to. The Expenditure Years are calculated based on multiples of the YearReplace record set...