About this tutorial:
Video duration: 4:58
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…