Need to display fields but only when another field is "xx"

S

Steve

I have a report that that shows canceled and completed jobs (3 and 4)
i only want to display the SalesSpiff amount if the job is completed.
I have tried to use the IIF([JobStatus]="3",[SalesSpiff],"") but i
cannot seem to make it work.

Any suggestions?
 
A

Andi Mayer

I have a report that that shows canceled and completed jobs (3 and 4)
i only want to display the SalesSpiff amount if the job is completed.
I have tried to use the IIF([JobStatus]="3",[SalesSpiff],"") but i
cannot seem to make it work.

Any suggestions?
Click to expand...

is [JobStatus] a report control?

is [JobStatus] a string?

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Top