totaling in a filtered form

  • Thread starter Thread starter pat67
  • Start date Start date
P

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
 
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
Click to expand...

try
=Sum(IIf([Exc Code]="20",[Open Value],0))
 
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.
Click to expand...
=IIf([Exc Code]="20",Sum([Open Value]),0)
Click to expand...
What happens is it totals 0
Click to expand...
Any ideas on this?
Click to expand...
Thanks
Click to expand...

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


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