summing in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with teo columns "copy type" and "sumofto total quantity". I
created a report wwith 3 columns with the following statement under each
column; =IIf([Copy Type] Like "Distr",[SumOfTotal Qty],""), ans in the other
2 clumns I've replaced "Distr" with "Store" and "Overs".
I would like to total the three columns in my report footer so I created
another statement as followes; =IIf([Copy Type] Like "Distr",Sum([SumOfTotal
Qty]),"") and in the other 2 columns again I've replaced "Distr" with "Store"
and "Overs".
When I run the report no error message is returned but no total show up.
What is wrong with my totals statements?
Thanks, John
 
Why are you using "Like" without wildcards (*). Also, your IIf might return
either a number or a string. That's not a good idea. Pick a data type and
stick with it.

Try control sources like:
=Abs([CopyType]="Distr") *[SumOfTotal Qty]
Your footer can use a control source for summing like:
=Sum(Abs([CopyType]="Distr") *[SumOfTotal Qty])
 
Back
Top