Difference Between Distinct and Distinct Row in Microsoft Access Queries

1
13




About this tutorial:

Video duration: 4:58
Introduction

In Microsoft Access, the SQL syntax of your query may say “Select Distinct” or “Select DistinctRow”. Are you familiar with the difference? Learn how this impacts which records and number of records you see, and whether they can be edited.

Unique Values and Unique Records Properties

When creating a query in Microsoft Access, you might want to return only distinct or unique values. There are two options in the query’s property sheet, “Unique Values” and “Unique Records”:

Microsoft Access Query Property Sheet

These properties correspond with the DISTINCT and DISTINCTROW…

1 COMMENT

LEAVE A REPLY