Sum for an unbound field

[jd_boss_hogg]

Hi All,

I have an unbound field on a report with the following data source..
=IIf([NET]=0,"100",[NET])

The '100' value will be replaced by something more significant once this gets working. Basicaly, it's a financial report looking at values of invoices.

How do i add up to total sum of these details in the footer of a report? Is it possible to SUM on an unbound field, because what field source do you use?

Hoping someone can help !

 

[jd_boss_hogg]

here i go again, answering my own posts! Sorry, will start to search more thoroughly before submitting posts from now on. Just found the answer on utteraccess..

basically, the IIf statement needs to go in the footer section as well, and not just a call to the control name. So, this works...
= Sum(=IIf([NET]=0,"100",[NET]))