Working with unique values

When you run a query, Access often returns what appear to be duplicate rows in the recordset. The default in Access web apps is to return all records. You can ask Access to return only records with unique values. When you ask for unique values, you’re asking Access to calculate and remove duplicate values in the returned recordset. If you want to see all possible data (including duplicate rows), leave the Unique Values property turned off. Note that the Unique Values property setting for all new queries is not turned on by default.

To understand how the Unique Values property setting works, create a new query that includes both the tblLaborHours table and the tblComments table. Let’s say you want to find out which employees ...

Get Microsoft Access 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.