Only display field based on another

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.
 
D

Duane Hookom

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) )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to display fields but only when another field is "xx" 1
IIf statement 9
Showing records based on status 4
label based on another field 3
Conditional Count with multiple expressions 4
Display Parameter choice On Report 7
sort by sum of a field 1
Max and Min will not display correctly 2

Top