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])
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])
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])
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
ControlSource is property of data control (textbox, listbox, combobox, checkbox) on form/report.
You want to exclude records where the expression returns 0?
<>0
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes. I did not express my need clearly.
Issue resolved?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
FYI I deleted your duplicate thread, so you should continue this one if you still need resolution.