var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am using the following DSUM on a continuous from;
=DSum("[Balance]","tbl_statements","[calculation_ref] =" & [Calculation_ref] & " And [transaction_date] <=" & Format([transaction_date],"\#yyyy\-mm\-dd\#"))+[balance_carried_forward]
The idea is to calculate the running total which works fine, unless there is more than one entry with the same transaction date.
How can I get this running total to calculate each unique line? I have statement_ref which is the primary key, I didn't know if I could total them using the < statement_ref first?