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)
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,
To compare result sets, click the TEST button using a query
with and then without the DISTINCT operator.