I am in the process of building a DB to show Employee Training Records using MS Access 2010.
I have a query which amongst other things consists of a Date Completed field (date), Frequency field (days) and Due Refresher Date field (which is a calculation of Date Completed + Frequency and displays a date).
What I am trying to do is create a field where if the Due Refresher Date falls within say December of this year then the field will display a 1.
I have tried using this expression; IIf([Due Refresher]=Month(Now()+3,"1","0") but it just displays a 0 where the Due Refresher Date is 13/12/2019.
I am obviously doing something wrong in the expression and would appreciate if someone could advise me where I am going wrong.
TIA