|
||||||
|
Odd or Even By Richard Rost ![]() ![]() 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?" MembersI'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! Links
|
||||
| |||
Keywords: TechHelp Access odd or even or odd mod modulus modulo integer division iif iseven isodd alternate page footers word even page odd page PermaLink Odd or Even? in Microsoft Access |