Hello again. I'm hoping someone can help me understand and fix a summing a text box

I have one field that has a formula like this:=IIf([System Notes]="Past Due",([Cost]),"")

I changed the name that this formula is in within the properties to “Past Due Box”

Now in the now text box I created I wanted to simply sum the all of the cost that shows up in the Past Due Box. I was assuming it would be something as simple as “=Sum([Past Due Box])” but that isn’t working. Any help would be greatly appreciated.

Thanks

Corey

Assuming you are summing on a continuous form (i.e) many records, and you don't filter the recordset, you can put an unbound field in the Footer or Header of the form, and use

DSum(...) for the records on this form, then you may have to update it if it doesn't role.

You can always just put the IIf in the query behind the form, QBF,and then use Sum(Expression) and then just try to use Sum(something). Then you have to query.

A little tricky but possible. Need to make sure you get what you want.
Just do one step at a time, to make sure the formula works.


Reports are much easier, they have rolling sums.


Database Agreements