Only display field based on another

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a field in a report that i only want to display if another
field has a 3. then i will only total jobs that were completed.

I have tried the following IIF([JobStatus]="3",[SalesSpiff],"") i have
tired with many different combinations but still cannot get this to
work.

Any help would be greatly appreciated.
 
If JobStatus is numeric, try:
=IIf([JobStatus]=3,[SalesSpiff],Null)
Make sure the name of the control is not the name of a field.
To sum this expression in group or report footer, use:
=Sum(IIf([JobStatus]=3,[SalesSpiff],0) )
 
Back
Top