G Guest Mar 24, 2007 #1 How would one make a calculated field in a query display a blank when the result = 0?
J John W. Vinson Mar 24, 2007 #3 How would one make a calculated field in a query display a blank when the result = 0? Click to expand... Two ways: IIf([result] = 0, "", [Result]) or set the Format property of the control in which you're displaying this (you shouldn't be displaying a query datasheet) to a "four value format" - four formats separated by semicolons, for positive, negative, zero or NULL values respectively: "#";"-#";"";"" to show 34, -32, blank or blank respectively. John W. Vinson [MVP]
How would one make a calculated field in a query display a blank when the result = 0? Click to expand... Two ways: IIf([result] = 0, "", [Result]) or set the Format property of the control in which you're displaying this (you shouldn't be displaying a query datasheet) to a "four value format" - four formats separated by semicolons, for positive, negative, zero or NULL values respectively: "#";"-#";"";"" to show 34, -32, blank or blank respectively. John W. Vinson [MVP]
