Access to recognise a field with a forumla in it!!!!

[wayne205]

In a report I have got the formula

=IIf([working]="Yes",[Value]/10,"0&quot

The above is working fine. It is saying that if the item is working ("Yes&quot, then divide its value by 10, else display a "0".

This is fine, but my problem is when I try to sum up the total of the above formula in the report footer. I don't seem to be able to reference the field by the name - i.e.

=Sum([Text36])

as it wants a parameter setting for Text 36 or something.

How can I sum the top formuala on my report?

I would more than appreciate anyone who knows how to do this / a way around it!

Thanks in advance.

Wayne

 

[dhookom]

You can't sum a control.
-change your Text36 expression to remove the "":
=IIf([working]="Yes",[Value]/10,0)
-change the control source of the sum to:
=Sum( IIf([working]="Yes",[Value]/10,0) )
You should also consider using a naming convention for you controls.


Duane
MS Access MVP

 

[wayne205]

DHOOKOM:-

Thanks for the reply! That has solved my problem! ;-)

Wayne