Use DLookup Not DCount, Query Properties, More!

In this Microsoft Access tutorial, I will show you how to efficiently check for related records using DLookup instead of DCount, discuss generating random order numbers, explain the difference between DISTINCT and DISTINCTROW in query design, demonstrate using SQL and query builders in forms and controls, offer tips for searching my website for specific topics, and answer questions about reminders for updating holidays in your database.

Prerequisites

• Quick Queries Listing
• Quick Queries #35

Links

• DLookup
• DCount
• NZ Function
• Reminder Popup
• Reminder Popup Date
• Do Records Exist

Recommended Courses

• Access Developer Courses
• Access Beginner 1

Up Next

• Quick Queries #37

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 Diamond Sponsors - Information on our Sponsors 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, DCount vs DLookup, using DLookup to check related records, unique values vs unique records, DISTINCT vs DISTINCTROW, query properties sheet, aggregate queries, sequential order numbers, generating random order numbers, SQL query builder in forms, editing Row Source SQL, advanced query options, search function limitations, DLookup multiple criteria, Access Index page, database reminders for holidays, Timer event reminders, OnOpen event reminders, finding TechHelp videos, channel membership options