Custom calculated field with condition?

Question

SQL

Hello!
I work with MS Access. There is a query that displays information of the following form:

ID_s	GroupNum	method	Max	Cur
one	one	one	20	eighteen
one	2	0	ten	ten

The task is the following: it is necessary to calculate one more column and display it (for example, 'Result') already from another query. The calculation should be made as follows (I will try to describe in pseudo-language)

если Method == 1 тогда
    если Max == Cur тогда
        Result = Max
    иначе Result = 0
иначе Result = Cur

Those. The result should be the following table:

ID_s	GroupNum	method	Max	Cur	result
one	one	one	20	eighteen	0
one	2	0	ten	ten	ten

How to implement this, and is it even possible to implement this?
I will be grateful for any help!

Answer 1

It turned out to be quite simple:

iif(Method,
   iif(Cur = Max, Max, 0)
  ,Cur
) AS Result

I don't know if this is the right way to do it, but it works.