I really have no idea!

[jodilees]

Hi everyone

I am hoping someone can tell me if I am I even on the right track with this.

This is something along the lines of what I have in my form, but it is not working.

=IIf(Nz([Form]![WIP]![Variation records subform1]![Total Variation Value])=' ',0,Sum([Form]![WIP]![Variation records subform1]![Total Variation Value])

I am trying to achieve this.

If the field Total Variation Value in my Variation records subform1 contains a null value then display a 0, if it contains a value show that value.

I have looked at some examples through help and also through this site, but can't relate any of them directly to what I am trying to achieve as they tend to use less than or grader than values on the Nz function.

Kind Regards

Jodi

 

[DALeffler]

try:

=iif(isnull(forms![mymainformname]![my sbfrm control name on main form].form![my control name on subform]),0,forms![mymainformname]![my sbfrm control name on main form].form![my control name on subform])

Doug.

 

[jodilees]

try:

=iif(isnull(forms![mymainformname]![my sbfrm control name on main form].form![my control name on subform]),0,forms![mymainformname]![my sbfrm control name on main form].form![my control name on subform])

Doug.

Got it working, thanks for your assistance.