Odd or Even
By Richard Rost 3 years ago
Determine if a Number is Odd or Even in Microsoft Access
Microsoft Excel has two nice functions that make it easy to tell if a number is even or odd (IsEven, IsOdd). Access has no such functions, however using the MOD (Modulus, Modulo) operator, we can easily determine that status.
Vishwanath asks, "Sir, how do you tell if a number is even or odd in Access?"
I'll show you how to recreate the IsEven and IsOdd functions from Excel in an Access VBA Module. You will also see how to print alternate even/odd page footers like you can do in Microsoft Word.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Odd or Even
Get notifications when this page is updated