Addinf Sum() gives error

[SAC]

I have a textbox in a datasheet form whose data source is:

=IIf([Forms]![frmEstrh]![txtCustTaxable]=-1,[txtPriceExt],0)

If I try to sum it in another control like this:

=Sum(IIf([Forms]![frmEstrh]![txtCustTaxable]=-1,[txtPriceExt],0))

I get an error.

Any ideas?

Thanks.

 

[Wayne Morgan]

Where is this other control located?

 

[SAC]

Thanks. I got it....went back to a previous version where it worked. I
must have had a typo.

Thanks for your help. I really appreciate it.

Where is this other control located?

--
Wayne Morgan
MS Access MVP

I have a textbox in a datasheet form whose data source is:

=IIf([Forms]![frmEstrh]![txtCustTaxable]=-1,[txtPriceExt],0)

If I try to sum it in another control like this:

=Sum(IIf([Forms]![frmEstrh]![txtCustTaxable]=-1,[txtPriceExt],0))

I get an error.

Any ideas?

Thanks.