S
Sarah
Hello -
I need to do calculations across values in the same field across multiple
rows in an Access query. For each account number I've got, there are several
transactions, and an interest rate is shown for each transaction. So, I
might have 5 transactions for account 111, two at a 9.5 interest rate, and
three at a 10.00 interest rate. If the interest rate changes over the range
of transactions for a single account, I need to determine the date of the
last transaction at the first interest rate. So, I need to compare the
values of the interest rates across rows of data, and then pull the
transaction date out of the row/record with the last instance of the lower
rate. Is this possible to do in an Access query? If not, any other
suggestions on how to obtain the information?
I need to do calculations across values in the same field across multiple
rows in an Access query. For each account number I've got, there are several
transactions, and an interest rate is shown for each transaction. So, I
might have 5 transactions for account 111, two at a 9.5 interest rate, and
three at a 10.00 interest rate. If the interest rate changes over the range
of transactions for a single account, I need to determine the date of the
last transaction at the first interest rate. So, I need to compare the
values of the interest rates across rows of data, and then pull the
transaction date out of the row/record with the last instance of the lower
rate. Is this possible to do in an Access query? If not, any other
suggestions on how to obtain the information?