access compare values and select higher of two

  • Thread starter Thread starter Captain Turtle
  • Start date Start date
C

Captain Turtle

In Access database I want to compare the values in two fields in a form and
then select the higher value, insert it into another field and then use in a
formula.

E.g. Value 1 = 500 Value 2 = 600, 600 to be inserted into another field
and then be multiplied.
 
In Access database I want to compare the values in two fields in a form and
then select the higher value, insert it into another field and then use in a
formula.

E.g. Value 1 = 500   Value 2 = 600,   600 to be inserted into another field
and then be multiplied.
Click to expand...

The formula for the third field is:

=IIF([Value 1]>[Value 2];[Value 1];[Value 2])

Groeten,

Peter
http://access.xps350.com
 
Back
Top