O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required