Hello All

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?

Thanks

Junk