If formula with three separate condititons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want my if formula to do the following:
If total owing is >0 it should say "Amount Outstanding"
If total owing is <0 it should say "Credit Remaining"
If total owing =0 it should say nothing i.e. null

How do i write the formula
 
If this is a text box on a form or report, you can set the format property
to:
Format: "Amount Outstanding";"Credit Remaining";"";""
 
I don't understand what you mean i've got an amount field it can either be >0
, <0 or =0. so the box next to it i want to say one of these three choices?
Please help
 
Set the control source of your text box to your total owing
field/expression. Then set its format:
Format: "Amount Outstanding";"Credit Remaining";"";""
 
But how will it know when to display what, where have i told it?
Click to expand...

I guess it's because Access is smart!!
Did you try Duane's suggestion. It will work.

For more information on his method, take a look in Access Help:
Format + Format Property + Number and
Currency datatypes
 
Hi Database user - try this. Note - [TO] is whatever your total owing field
is called

iif( [TO]>0,"Amount Outstanding",iif([TO]<0,"Credit Remaining"," "))

The first IIF stmt checks if [TO] is greater than 0 and inserts the text
Amount Outstanding if that is TRUE. If it is FALSE is goes on the the next
test and inserts the text Credit Remaining is that test is TRUE. If neither
are TRUE it defaults to " " which is just a blank field.

Hope this helps - Yours - Dika
 
Back
Top