Criteria to suppress zero amount from expression

[George Pollow]

Here is my expression. What is the Criteria command to suppress the zero balance?



Avail_3: ([Inventory_3]+[Sum Of 3_In]-[Sum Of 3_Out])

[June7]

What do you mean by 'Criteria command'?

Display of 0 can be suppressed with expression in textbox ControlSource:

=IIf([Avail_3] = 0, Null, [Avail_3])

[George Pollow]

What do you mean by 'Criteria command'?

Display of 0 can be suppressed with expression in textbox ControlSource:

=IIf([Avail_3] = 0, Null, [Avail_3])

I am using Access 2000. To the left of the grid in Design View, there are titles for each line like Field, Table, Total, Criteria. I tried copying your statement to the Criteria line but it did not work. I cannot find ControlSource.

[June7]

ControlSource is property of data control (textbox, listbox, combobox, checkbox) on form/report.

You want to exclude records where the expression returns 0?

<>0

[George Pollow]

Yes. I did not express my need clearly.

[June7]

Issue resolved?

[pbaldy]

FYI I deleted your duplicate thread, so you should continue this one if you still need resolution.