Hello,
So I did this is Excel and now am trying to get the same result in an Access query. So in Excel I am using a math function; a set number(60)*the value in the previous row. i.e. - 60*[Balance].
So if I have 10 rows, the first row will get the number from another field and beginning at the second row it will get the number from the previous value in another field. (lets say the 2 fields are [Total] & [Balance].
The first row would = 60*[Total] and beginning at the second row = 60*[Balance](row 1 value), third row = 60*[Balance](row 2 value), etc.
In excel it looks like 60*H18, 60*H19, 60*H20, etc. How do I do this same thing in a query?
My query already breaks up into the correct number of rows and I'm trying to get this piece to work also.
Any help is GREATLY appreciated. Thank you,
Brendan
So I did this is Excel and now am trying to get the same result in an Access query. So in Excel I am using a math function; a set number(60)*the value in the previous row. i.e. - 60*[Balance].
So if I have 10 rows, the first row will get the number from another field and beginning at the second row it will get the number from the previous value in another field. (lets say the 2 fields are [Total] & [Balance].
The first row would = 60*[Total] and beginning at the second row = 60*[Balance](row 1 value), third row = 60*[Balance](row 2 value), etc.
In excel it looks like 60*H18, 60*H19, 60*H20, etc. How do I do this same thing in a query?
My query already breaks up into the correct number of rows and I'm trying to get this piece to work also.
Any help is GREATLY appreciated. Thank you,
Brendan