As for Access to find the maximum value of the three cells in a table?

Can not seem to find a formula how to find the maximum value of the three table cells and write it to another cell...
Or but to create cells with intermediate results and compare the answers, other variants are not present?
June 27th 19 at 15:34
1 answer
June 27th 19 at 15:36
Solution
The second link leads to a 404 error.
And the first link I described how to show the maximum value from a column...
I want to display the maximum value from multiple cells and not from a column... - Alanis.Kris commented on June 27th 19 at 15:39
The Microsoft Access Max function returns the maximum value in a set of numeric values in a select query.
As the query is built, there will look. If you cells are located at random and not known beforehand, how are you going to handle them programmatically?
PS the Link was corrected - tyreek_Heidenreich commented on June 27th 19 at 15:42
: Cells are not arbitrary, the fact that the query using the function "Results", choose "maximum value" from a column.
And I need to select max value from multiple cells lines of the table.
That is, here is an example of the base:
https://yadi.sk/d/rg0BS6hy3GjcGi
Where it is necessary to find the maximum value in each row, not column and record it in cell MAX.
That is, in this case, we have in the max column to record the numbers 6, 60, 600...
Tried to make the design of type select max([A], [B], [C}), but it's not working, at least in Excel all hang out:( - Alanis.Kris commented on June 27th 19 at 15:45
Obviously, you have a base curve. Then perhaps you can help here is allenbrowne.com/func-09.html or https://support.microsoft.com/en-us/help/209857/ac...
If not, if not, you
any way to reverse engineer and normalize database
or to live with Excel-em - tyreek_Heidenreich commented on June 27th 19 at 15:48
: What do you mean "curve" in the sense of not well-formed? But how to generate? Or maybe a competent article "treat"?

And on account of the article at the link, is not quite clear... This is an example of a function? I can not understand how to use it...
I have Access 2010 in the "Working with databases" and chose "Visual Basic", has created a new Modul, copied it to the formula from the article,clicked Run and went out. Then in the database I tried to create a new line of type "Calculated" to insert code " Maximum([A],[B],[C]) ", also I tried to insert this code in a new cell query is not working:(

By the way, do not understand the first paragraph of the article: "Open the sample database Northwind.mdb.", this is how to perform, what's that all about, can I not go there? - Alanis.Kris commented on June 27th 19 at 15:51
1. Select any to search for "Designing relational databases".
2. This is an example of running the function. How to create and use your own functions in Access, you can read the documentation on MS Access or popular literature.
3. Link to article on training to work with MS Access, there is a database example Northwind.mdb - tyreek_Heidenreich commented on June 27th 19 at 15:54
: 1. I suspect that not properly built base, but to "poke his nose" not who it was:( Thanks, I will study:) - Alanis.Kris commented on June 27th 19 at 15:57

Find more questions by tags Microsoft Access