blackcat9000
Programmer
Hi yer folks.
I have a form to showing a list of people who have paid membership fees for a year by having a value in the fees checkbox.
I am trying to provide a IIf statement or criteria to say if the year the fee was paid is not equal to the current year then change the fees checkbox value to false
IIf([feeyear]=Year(Now()),[Fees]=true,[fees]=false)
Can anyone help
Thanks in advance
I have a form to showing a list of people who have paid membership fees for a year by having a value in the fees checkbox.
I am trying to provide a IIf statement or criteria to say if the year the fee was paid is not equal to the current year then change the fees checkbox value to false
IIf([feeyear]=Year(Now()),[Fees]=true,[fees]=false)
Can anyone help
Thanks in advance