Minus equal null

  • Thread starter Thread starter ياسر
  • Start date Start date
Ù

ياسر

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
Jeff Boyce said:
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
Click to expand...
i
" representing "none".
 
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
 
Back
Top