Рет қаралды 2,653
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?"
RESOURCES:
MOD Operator: 599cd.com/modulus
IIF Function: 599cd.com/iif
BONUS FOR CHANNEL MEMBERS
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will 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.
MEMBERS ONLY VIDEO: • Is a Number Odd or Eve...
Become a member here: / @599cd
LINKS:
FREE Customer Template Database: 599cd.com/XCDT
FREE Access Level 1: 599cd.com/Free101
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/TechHelp
Learning Connection 50% OFF: 599cd.com/Connection
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/AccessForum
Twitter: / learningaccess
Email Me: amicron@gmail.com
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
TOPICS COVERED IN MEMBER VIDEO:
Create Your Own Functions: 599cd.com/XHQEK4
Immediate Window: 599cd.com/1188
Alternate Background Colors: 599cd.com/XAC13X6
Force New Page After Section: 599cd.com/XAC13X6
Page of Pages: 599cd.com/XDPGB6
Report Section Build Event: 599cd.com/X6WWV