Baby Steps they say lol.
I've got a Query displaying transaction History for a specific invoice. I've added a field to the Query to calculate the running total via building an expression
SubTotal: Dsum("Totals","InvTransQ")
It works fine except for the very first SubTotal. It doesnt show the amount in Total but the Difference between the 1st and second record. I understand it in the second rcord and so on but th first?
Does anyone know how t fix this ?