Changing numbers from positive and negative

J

jcdifi26

I'm using Access 2003. In a report I have a field named List Price.
The data is always a positive number. I have another field named I-C
that displays and I for invoice and a C for credit. If the field is a
C I want to display the List price as a negative number. Is there a
way I can do that?
 
K

Ken Snell [MVP]

In the control source for the control that likely currently is bound to the
field named List Price, put this expression:

=IIf([I-C]='C',-1,1) * [List Price]
 
F

Fons Ponsioen

And do not forget to rename the textbox otherwise you'll
get "ERROR"
Fons
-----Original Message-----
In the control source for the control that likely currently is bound to the
field named List Price, put this expression:

=IIf([I-C]='C',-1,1) * [List Price]

--

Ken Snell
<MS ACCESS MVP>

I'm using Access 2003. In a report I have a field named List Price.
The data is always a positive number. I have another field named I-C
that displays and I for invoice and a C for credit. If the field is a
C I want to display the List price as a negative number. Is there a
way I can do that?
Click to expand...


.
Click to expand...
 
Top