Excel function in access db

Question

How to use excel function in access db? We have a policy numbers I would like to know if the policy number repeats return 0 otherwise 1

In excel: =IF(A2=A1),1,0

How can I write this formula in access?

Please appreciate your help.

Thanks.

In MS-Access already have IIf ( expr , truepart , falsepart). Article link — Harun24hr
– Harun24hr, Commented Aug 28, 2019 at 2:24

Gustav · Accepted Answer · 2019-08-28 05:47:38Z

1

In Access VBA you would use a Boolean (True/False)

Match = (Value2 = Value1)

If you insist, that Match must be an Integer, this will do:

Match = Abs(Value2 = Value1)

In a query it would be like:

Match: Abs([Field2]=[Field1])

answered Aug 28, 2019 at 5:47

Gustav

56.3k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1