totaling in a filtered form

[pat67]

Hi. I have a form that shows the open orders. I can filter by vendor.
I can total all of the orders when i filter. But what i am trying to
do is total based on the criteria of a field. I created a text box
that would show the total value of orders we need to move out. the
formula is as follows in the control source of the text box.

=IIf([Exc Code]="20",Sum([Open Value]),0)

What happens is it totals 0

Any ideas on this?

Thanks

 

[Bob Quintal]

Hi. I have a form that shows the open orders. I can filter by vendor.
I can total all of the orders when i filter. But what i am trying to
do is total based on the criteria of a field. I created a text box
that would show the total value of orders we need to move out. the
formula is as follows in the control source of the text box.

=IIf([Exc Code]="20",Sum([Open Value]),0)

What happens is it totals 0

Any ideas on this?

Thanks

try
=Sum(IIf([Exc Code]="20",[Open Value],0))

 

[pat67]

Hi. I have a form that shows the open orders. I can filter by vendor.
I can total all of the orders when i filter. But what i am trying to
do is total based on the criteria of a field. I created a text box
that would show the total value of orders we need to move out. the
formula is as follows in the control source of the text box.

=IIf([Exc Code]="20",Sum([Open Value]),0)

What happens is it totals 0

Any ideas on this?

Thanks

try
=Sum(IIf([Exc Code]="20",[Open Value],0))

I actually tried that and obviously it worked. Thanks for the help