UniqueRows (Property)

Applies To:

QuerySection

Description:

Returns or sets the value of a Query section unique row property. Setting this property to true causes the query to return only unique rows of data by eliminating duplicate rows from the data set retrieved by the query.

Action:

Read-write, Boolean

Example:

This example sets each query in a document to return unique rows.

var SecCount = ActiveDocument.Sections.Count
for (j = 1; j <= SecCount ; j++)
     {
      if (ActiveDocument.Sections[j].Type == bqQuery)
            ActiveDocument.Sections[j].UniqueRows = true
     }