Formula that require 'cell selecting'

[hahahaha]

I am using windows 7 32-bit and access 2016. Its for work. I simply need to key in a formula that is like Excel's version of '=IF(A3>A2, "YES", "NO")'
I cant seem to find this information anywhere.


I have tried using queries but I still do not know how to solve for 'A3' and 'A2' in Access.
Using Excel is very laggy since I have about 25k rows of data...

Is it possible to have such formula in Access? Or I have no choice but to do it in Excel?

[rpeare]

if you are attempting to create a formula in a query using data elements on a table

Test: iif([Field1] > [Field2], "Yes", "No")

If you are attempting to test values on a form

Test: iif([forms]![formname]![fieldname] > [forms]![formname]![fieldname2], "Yes", "No")

if you are attempting to test values on a form and return the value on the form (not in a query)

the control source property would be

=iif([fieldname] > [fieldname2], "Yes", "No")

[orange]

As rpeare advises, the IIF (immediate If) is the function in Access vba.