Calculating a balance at at fig.

[bwian1234]

I am working on a statement report. We have a table with 4 fields - client-ref, date, invoice, payment



I have a text box on my form with a button to trigger the report. The text box is for a date that the statement is to run FROM. (they always run up to today)

The report displays everything fine, but I want a balance outstanding displaying on the report at the first date (the text box)

So I need to total all the invoices and all the payments UP TO the date in the text box, deduct Payments from Invoices then Pass that figure to the report.
then display all dates, invoices and payments FROM the date in the text box, up to today.


sorry, I'm not very good with the queries and I am looking for a kind soul to guide me through how I do it.

can anyone help?
thanks

[pbaldy]

You can use a DSum() function, using the textbox as a criteria (less than).

DLookup Usage Samples