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 15 - Group records
Use
the Group By operator to group records. Notice this
syntax creates a new calculated field on the fly in SQL.
SELECT SupplierID
FROM Products
GROUP BY SupplierID