Find Gaps in Check Number Sequence in Access

In this Microsoft Access tutorial, I will show you how to find gaps in your check number sequence using the check register database. You'll learn to use VBA, the IsNumeric function, the NZ and DLookup functions, and perform loops to identify missing checks efficiently.

Carlos from Pflugerville, Texas (a Platinum Member) asks: I'm using your Check Register TechHelp database. Is there any way to quickly figure out if there are any missing checks from the register? For example, if I've for 101, 102, 104, and 105, I'd like the database to tell me 103 is missing.

Prerequisites

• Check Register
• Intro to VBA
• IIF Function
• CLng Type Conversion
• IsNumeric
• For Next Loop
• NZ Function
• Variables
• Null
• DMin
• Dmax Function
• Dlookup Function

Recommended Courses

• Check Register Seminar
• Check Register Template Only

Up Next

• Missing Check Numbers, Part 2

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.

Keywords

TechHelp Access, find gaps in check number sequence, identify missing checks in database, gap detection in Access, check number sequence VBA, missing check numbers report, if function in Access, immediate if usage, CLNG conversion, isNumeric function Access, forNext loop Access, Dmin function Access, Dmax function Access, Dlookup function Access, nz function Access, query design Access