Using Microsoft Office for Mac as a Relational Database

By Jim Gordon, co-author of Office 2011 for Mac All-in-One For Dummies.

Part 14 - Return unique records (no duplicate records)

To return a set of records that contain only one of each unique entry within a field, add DISTINCT to the SQL command. You must use SQL View, not Query view.

This query returns the names of the products for which orders have been placed.

SELECT Distinct Products.ProductName FROM Products, Order_Details WHERE (Products.ProductID=Order_Details.ProductID)

To compare result sets, click the TEST button using a query with and then without the DISTINCT operator.

Part 1
Part 13( Previous)
Part 15 (Next)