SumIf type function

[puforee]

I have a form where I log Expenses and Income. I use the same value field for each... "Amount". The difference depends on if the "Expense" checkbox or "Income" checkbox is checked. Only one can be checked per record.

So, I want to show running totals for "Expense" and "Income" in my form header. In Excel I would do a SumIf statement and sum "Amount" if "Expense" is checked. And a Sum "Amount" if "Income" is checked. I would like to create two objects in the header of my form that would show the running total of Income and Expense.

How can I mechanize this?

Thanks,

 

[genomon]

two objects in the header of my form that would show the running total

Well, you could use the DSum() function with WHERE criteria, and programatically refresh the contents of a header text box or label after a form event fires.

Cogito eggo sum – I think, therefore I am a waffle.

 

[puforee]

Worked great....thanks,