Hello Dear's

[ezat]

Hi gays
i have a problem:
please help me about Maximum between 5 fields all records Number.
I know between 2 for examlple:
Max=iif([h1]>[h2],[h1],[h2]) in query.
how about for 5 fields h1.....h5?
thanks for your answers.

 

[NauticalGent]

Hello and welcome to AWF.

 

[isladogs]

Hello and welcome.
In theory you could extend your formula using nested If statements.
However, the fact that you are asking the question suggests that your table structure isn't normalised

 

[NauticalGent]

However, the fact that you are asking the question suggests that your table structure isn't normalised

I answered to give it a bump, but I am too tired to engage...

 

[The_Doc_Man]

You would do well to look up "Normalization" in this forum, or in the general web look up "Database Normalization."

Your question suggests that you have data laid it in what we call "flat-file" orientation, which is horizontal in nature. Access works best in a more vertical or hierarchical orientation. In normalized data, your question becomes almost trivial. In a horizontal orientation, you question becomes painful because of the complex typing involved.

 

[theDBguy]

Hi. Welcome to AWF!