|
||||||
Quick Queries #36 By Richard Rost ![]() ![]() 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. PrerequisitesLinksRecommended CoursesUp Next
KeywordsTechHelp 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
|
||||||||||||||||||||||||
| |||
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 i PermaLink Microsoft Access Quick Queries #36 |