The use of switch instead of the case while then else end in Access is not supported

The use of switch instead of the case while then else end in Access is not supported

The main point here is to implement multiple fields in a table, compare multiple fields and then get the maximum or minimum value to handle

Case and then else end example

Selece F1,f2, (case if F1>f2 then F1 else F2 end) as a from table

But finding that in Access does not make

Next, use the switch supported by Access instead of the following

SELECT * FROM (    select Topvalue,bottomvalue,leftvalue,rightvalue,    switch    (        a > B,a,        a <= b,b    ) as result    from    (        select Topvalue,bottomvalue,leftvalue,rightvalue,        switch        (            Topvalue > Bottomvalue,topvalue,            topvalue <= bottomvalue,bottomvalue        ) as a,        switch        (            leftvalue > Rightvalue,leftvalue,            leftvalue <= rightvalue,rightvalue        ) as B        from Imagehandle    )) Order BY result Desc
The query results are as follows


Record this first, haha

The use of switch instead of the case while then else end in Access is not supported