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?"

Members

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.

•  Extended Cut Video - Silver

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• MOD Operator
• IIF Function
• Create Your Own Functions
• Immediate Window
• Alternate Background Colors
• Force New Page After Section
• Page of Pages
• Report Section Build Event

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.