Search results

I have a form with sub form. The sub form shows data in Date Order and as entries are added I have a button that sorts this in date order as well. I need to be able to grab the previous row (after sorting) to calculate a currency so example: Row 1 - 2/1/24 - £2 Row 2 - 1/1/24 - £1 After Date...