display balance report

[markbrum]

Hi,

I need to show opening and closing balance on my report, i can draw the information from a running sum but if someone runs a report on say 07/20/04 to 07/27/04 the starting balance needs to be the value before 07/20/04, how do I call this?

Thanks for looking,
Mark.

 

[jksmi]

Hi,
if you use DSum to calculate your running totals in the query that the report is based upon and the criteria transaction date between(#07/20/04#, #07/27/04#) is in the where clause then DSum will sum all transactions to 20/07/04 for your opening balance.

If you aren't using DSum it would look something like

NET_TRANS: nz(DSum("TRANS_AMOUNT","TRANSACTIONS","[TRANS_DATE] <= Format(#" & [TRANS_DATE] & "#,'mm/dd/yyyy')"),0)

HTH, Jamie