Even though the query used when running the duplicate report isolates only a portion of the database the duplicate report will still look for possible duplicates accounts outside  the results of the query.

For example, if you were to query on accounts that may have been "created" in the past month. This query may only gather 100 accounts. If you were to run the duplicate report using that query, the duplicate report will search for possible duplicates in the entire database and return those that may be possible matches for the 100 accounts found by your query.

If your organization needs to isolate a specific number of accounts, the simplest way to restrict your query is by using a criteria that restricts accounts by a range of account numbers.

You can set up a query that restricts by account number as follows:

1.       Select Queries in the menu bar
2.       Click on a category that you want to store this query in
3.       Click New Query under the tasks menu
4.       Name the query
5.       Set the Starting criteria to Base/All Constituents
6.       Set the Data Return Type to Accounts
7.       Set the Match to All Of My Criteria
8.       Choose Account from the Available Fields drop down menu and click on Account Number
9.       Fill in Greater Than Or Equal To / 1     and Less Than Or Equal To / 10,000
10.    Click Save and Preview

Segmenting your database into a handful of queries will allow you to run your duplicate report on your entire database after a few iterations.

 * Note: To isolate a specific number accounts, the 'account number' range may need to be adjusted.  Account Numbers are not re-used.  If you delete or merge an account, that account number is not reassigned to a new account.  So if you query on account numbers 1,000 - 2,000, you many not end up with 1000 accounts in the query results.