How to have a constituent only show up once in a query. This can only be used if the row is a true duplicate. For example, if phone numbers are outputted in the query and a constituent has two phone number, the constituent will show up twice.
1. Drag Constituents\System record ID to the output fields. 2. In the Output Fields section, highlight System record ID. 3. Click the summation button and choose Count.