Value over ride in Query, Choose the highest value in Query, need

[Terry]

Hi

I have three field in the Query: A B and C. The table is as low

A B C D
1 2 3 3
2 2 1 2
3 1 1 3

I want an expression in query, that will allow me to have field D, which
choose the highest value among ABC fields. thanks.

 

[Klatuu]

Since this is an Access newsgroup and not an Excel newgroup, I will give you
an Access answer.
Create a calculated field in your query:

d: iif(a > b and a > c, a ,IIf(b > c, b, c))

 

[Marshall Barton]

I have three field in the Query: A B and C. The table is as low

A B C D
1 2 3 3
2 2 1 2
3 1 1 3

I want an expression in query, that will allow me to have field D, which
choose the highest value among ABC fields. thanks.

You can create a function to do that. See
http://allenbrowne.com/func-09.html