When building a SELECT query, you can set two options that affect which rows will be returned.
To return only the unique values from a column, or unique combinations of values from multiple columns, select the DISTINCT records check box. This removes duplicate rows from the query result set.
To remove this option and allow duplicate rows in the query result set, clear the DISTINCT records check box.
You return only the top n rows or the top n% of the rows in the result set, select the TOP records check box and enter the number or percentage of rows you want to return. To specify a percentage instead of a number, select the PERCENT check box.
To remove this option and return 100% of the rows, clear the TOP records check box.
Some data sources do not support the TOP or TOP n% options.
After you have set the SELECT query properties as you want, click Close.
More: