I have a table that sums a field ie. =Nz(Sum([Actual Quantity]),0) -now i want the report to exlcude this value if the Sum is 0
I have a table that sums a field ie. =Nz(Sum([Actual Quantity]),0) -now i want the report to exlcude this value if the Sum is 0
Base your report on a query, and in that query include a clause that says Actual_Quantity Is NOT Null
It is based on a query
I need to know how to provide >0 criteria for a calculated field ie. =Nz(Sum([Actual Quantity]),0)
Please post your query SQL.
Then why use Nz()?
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.