Select the larger of two values in a query

[matteozz]

Hello everyone!
I created a table with numerical values: length, width, height, weight. Then I created a query in which I entered the fields mentioned above and then, in a new field of the query I put a formula to find a specific data TOT CUBIC METERS: (([SIZE]! [LENGTH] * [SIZE]! [WIDTH] * [SIZE]! [HEIGHT]) / 1000000) * 250.


This formula works by filling in the fields Length, width, height. Now, however, I would make sure that the number derived from the expression is placed in relation to the weight of the table DIMENSIONS field and I return the greater of the two.

I do not know where to turn !!
Thanks for your help

[ranman256]

I'm guessing SIZE is a table name. You should look into access nominclature; like tables start w T....tSize It helps debugging.

METERS: (([LENGTH] * [WIDTH] * [HEIGHT]) / 1000000) * 250.

This should give the correct answer. But I;m not sure what you're asking to return.

[matteozz]

Thanks for your reply!
The result from the expression that I made is correct. Now I need to use this result and compare it to another number and I want that appears the largest one. I also precise thet the place of these two numers can change: maybe the largest is the number from the expression or vice versa. I tried this 0.5*((A+B)+abs(A-B)) but it found only one of the two numbers...

[CJ_London]

try

iif(A>B,A,B)

[matteozz]

try

iif(A>B,A,B)

I think that I solved it using this formule:

0.5*((A+B)+abs(A-B))

What do you think about it?
Thanks

[CJ_London]

yes that seems to work, interesting alternative way - I've learned something new today!