Exclude duplicate rows in a query (ADP)

If you want to see only unique values in a result set, you can specify that you want to exclude duplicates from the result set.

1. In the Database window, click Queries under Objects, click the query you want to open, and then click Design on the database window toolbar.
2. Right-click the background of the Diagram pane, then choose Properties from the shortcut menu.
3. Select DISTINCT values.

   The Query Designer inserts the keyword DISTINCT in front of the list of display columns in the SQL statement.

   Note   If you use the DISTINCT keyword in Microsoft SQL Server, you cannot modify the data in datasheet view.