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?