access compare values and select higher of two

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.
 
X

XPS350

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Autonumber field in Excel that behaves the same as Access 0
Word macro that can call cells out of Excel for a find and replace 0
Creating a Search using a combo box and then creating a report. 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Dynamic Naming of Form Button 3
Expression comparing two values yields wrong results 5

Top