Mod Function in Query

[DBFIN]

I want to use the mod function in a query to evalate whether the "Year" field contains an even or odd year. Years 2016 ,2014, 2012 would be even and years 2015, 2013, 2011 would be odd. How can I use the mod function to do this ?

 

[Minty]

Year is a reserved word - so might be worth changing it to avoid error and confusion. Have a look at this thread; http://www.access-programmers.co.uk/forums/showthread.php?t=287453

 

[RogerCooper]

I want to use the mod function in a query to evalate whether the "Year" field contains an even or odd year. Years 2016 ,2014, 2012 would be even and years 2015, 2013, 2011 would be odd. How can I use the mod function to do this ?

Assuming you are referring to the current date you could write

iif(year(date()) mod 2=0,"even","odd")

 

[DBFIN]

Thanks everyone for your quick replies. Your comments provided the perfect solution to my issue.