Sum If on Report

[Guest]

I need a report to list the sum of Military and Non Military orders. The
Military orders are distinguished by having the name "GEORGIA PACIFIC CORP"
or "GEORGIS-PACIFIC CO". The sales information I need to total is in InvQty
field. Trying to create a SumIIf function to tell it to sum the InvQty field
if the Name field is either equal to "GEORGIA PACIFIC CORP" or
"GEORGIS-PACIFIC CO" for the Miltary Totals or not equal to those names for
the Non Military Totals. I tried using the SumIIf function below, but I get
the same totol for both functions. The totals it gives me is the total for
both military and non military together?


=Sum(IIf([Name]="GEORGIA PACIFIC CORP" Or "GEORGIS-PACIFIC CO",[InvQty],0))

=Sum(IIf([Name]<>"GEORGIA PACIFIC CORP" Or "GEORGIS-PACIFIC CO",[InvQty],0))

 

[Al Camp]

Supe,
Try...
=Sum(IIf([Name]="GEORGIA PACIFIC CORP" Or [Name] ="GEORGIS-PACIFIC CO",[InvQty],0))

 

[Guest]

That did it. Thanks.

Supe,
Try...
=Sum(IIf([Name]="GEORGIA PACIFIC CORP" Or [Name] ="GEORGIS-PACIFIC CO",[InvQty],0))
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I need a report to list the sum of Military and Non Military orders. The
Military orders are distinguished by having the name "GEORGIA PACIFIC CORP"
or "GEORGIS-PACIFIC CO". The sales information I need to total is in InvQty
field. Trying to create a SumIIf function to tell it to sum the InvQty field
if the Name field is either equal to "GEORGIA PACIFIC CORP" or
"GEORGIS-PACIFIC CO" for the Miltary Totals or not equal to those names for
the Non Military Totals. I tried using the SumIIf function below, but I get
the same totol for both functions. The totals it gives me is the total for
both military and non military together?


=Sum(IIf([Name]="GEORGIA PACIFIC CORP" Or "GEORGIS-PACIFIC CO",[InvQty],0))

=Sum(IIf([Name]<>"GEORGIA PACIFIC CORP" Or "GEORGIS-PACIFIC CO",[InvQty],0))