I have a query that includes a couple running total fields using DSum.
I need a way to find the first instance (DFirst?) where the value in field B for any record (sorted by a date field) exceeds the value of field A for a specific record. I'm not looking for where B exceeds A in a single record, but using a specific value for A, find the first record where B is greater.
My efforts with the DFirst function have been lame and only returns the first instance of B > A in the same record. I think I need an expression to reference a specific record versus all.