# Dupl Address Report
Circulation can create a report listing all duplicate addresses in the Circulation database. Using the report, you can locate problem addresses, and run Duplicate Address Edit more efficiently. The criteria for determining duplicate addresses is the same in both functions (see the table on [Dupl Address Edit](/circulation-user-manual/11-utilities/subscription-address-menu/dupl-address-edit.md)).
#### To create this report:
* Select Duplicate Address Report from the Subscription/Address menu to display the Duplicate Address Report screen.
* Select Add and enter the ID of the first address number you want included in the report in Starting Address. Also indicate whether the report should include only exact matches.
* Select Continue to process the report.
#### Example—Duplicate Address Report
## Dupl Address Purge
Duplicate Address Purge allows you to remove all duplicate addresses after a specified address number, at one time. The address with the lowest address number is retained, and occupant and subscription information associated with duplicate addresses is automatically assigned to the remaining address. If duplicate occupants are encountered (i.e., first name, last name, and phone are a perfect match), the oldest occupant record is kept.
To qualify as duplicate addresses, two addresses must have the same:
* Zip
* Street
* House #
* House Modifier (for example, “a” in 401a Portland Ave”)
* Street Prefix (“North” in “36 North Portland Ave”)
* Street Suffix (“North” in “36 Portland Ave North”)
* Street Type (“Ave” in “36 Portland Ave”)
* Unit #
{% hint style="info" %}
Note: Use Duplicate Address Purge only if you want to get rid of all duplicate addresses within the database. For example, if many of your addresses have rural routes, you should not use this option.
{% endhint %}
To purge duplicate addresses:
* Select Dupl Address Purge from the Subscription/Address menu to display the Duplicate Address Purge screen.
* Select Add. In Starting Address, enter the ID of the address where purging should begin (addresses with a lower ID number will be skipped). Also indicate whether the report should include only exact matches (exact matches must match on all of the items listed on [Dupl Address Edit](/circulation-user-manual/11-utilities/subscription-address-menu/dupl-address-edit.md)).
* Select Continue to begin purging duplicate addresses. In this process, Circulation automatically reassigns all information associated with each address in a set of duplicates to the one retained address. For example, if the addresses whose IDs are 45, 2615, and 10045 are duplicates, only address 45 is retained in the database and all information associated with addresses 2615 and 10045 is assigned to address 45.
* As part of the purge process, the Duplicate Address Purge report will be created.
#### Example—Duplicate Address Purge Report
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.navigaglobal.com/circulation-user-manual/11-utilities/subscription-address-menu/dupl-address-report.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.