Excluding data (1 Viewer)

[BoroLee]

I have a report which is grouped by Committee. What i want to be able to do, is to exclude printing the Committee detail, if the Committee total is NIL.

I'm sure I will need to write some code, and any advice would be appreciated.

Thanks.

 

[jstand6]

You will want to use the IIf(IsNull([Field]), True Part, False Part) expression in the Control Source field of your text box.

Basically, if you want to exclude the committee detail if committee is NIL (Null), enter the following code as the Control Source:

IIf(IsNull([Committee Total]), "", [Committee Detail])

Basically, this code says if the field Committee Total contains a Null value, display nothing ("") in the text box, but it the filed Committee contains a value, display the Committee Detail in the text box.

Or, if you are using a query or expression to calculate the total, and the total is stored as a field titled Committee Total, you can use:

IIf([Committee Total] = "0", "", [Committee Detail])



[This message has been edited by jstand6 (edited 02-21-2001).]