Minus equal null

[ياسر]

i have report that calculate some text.
but i don't want to get minus values in the results
i want to set the numeric value with sign minus to zero
so what do i have to do ?

 

[ياسر]

thank you for your fast respond
then
dear sir:
sorry i don't know how to let you know what i need but i tried to explain
in my reports there is some fields that subtract and multiply results
for some items such as:
i have field to get the difference of start date and date now and working good
and i have text unbound to subtract total for another field with the
difference of years and i don't want the difference to be with minus values
all i need is to let the minus values be equal to zero.
so i wish that you could understand my explanation and hope to help me
by example please
thank you again

A point of semantics ... the character "0" represents the quantity "none of
it", where a "null" means an unknown.

I suspect you are referring to a "0

i
" representing "none".

 

[tina]

kind of hard to give you an example, when you haven't given us an example -
we can't see what expression you're using to "subtract total for another
field with the
difference of years". so here's a somewhat vague example, as

IIf(ControlA - ControlB < 0, 0, ControlA - ControlB)

hth

 

[ياسر]

thank you so much thats worked with me
and sorry to waste your time
again thanks so much

 

[tina]

you're welcome

thank you so much thats worked with me
and sorry to waste your time
again thanks so much