M Mike C Jul 7, 2004 #1 I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance.
I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance.
R Rick Brandt Jul 7, 2004 #2 Mike C said: I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance. Click to expand... =IIf([FieldName] < 0, 0, [FieldName])
Mike C said: I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance. Click to expand... =IIf([FieldName] < 0, 0, [FieldName])
M Mike C Jul 7, 2004 #3 That worked, thank you very much. -----Original Message----- Mike C said: I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance. Click to expand... =IIf([FieldName] < 0, 0, [FieldName]) -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com . Click to expand...
That worked, thank you very much. -----Original Message----- Mike C said: I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance. Click to expand... =IIf([FieldName] < 0, 0, [FieldName]) -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com . Click to expand...
F fredg Jul 7, 2004 #4 I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance. Click to expand... You can use the Control's Format property to do this. Set the property to: #;0;\0 See Access Help files regarding format Property + Number and Currency datatypes Or, if this field is part of a concatenated control: ="The amount due is $ " & Format([ControlName],"#;\0")
I would like to have all negative numbers show as 0. How can I set the properties in a report to do this? Thanks in advance. Click to expand... You can use the Control's Format property to do this. Set the property to: #;0;\0 See Access Help files regarding format Property + Number and Currency datatypes Or, if this field is part of a concatenated control: ="The amount due is $ " & Format([ControlName],"#;\0")