Top Count – Limits the number of records displayed to the number selected in this field.
Note The Top Count option limits the number of records displayed for the query, but the system could contain more records than there are displayed.
Note Show Distinct and Show Count affect one another when both are selected. For example, Show Count selected alone returns 1,000 records. Show Distinct is then selected along with Show Count, and the system returns 700 records, indicating that Show Distinct eliminated 300 duplicate records.
Note If a query specifies values that are different than the selections for Year, Exclude Deleted Properties, and Include Parent Properties in the toolbar, the values in the query overwrite the values in the toolbar.
For example, if the Year field contains a value of 2007, but in the query the prop_val_yr field is selected with a condition for values 2004, 2005, and 2007, the system returns results for all three years specified within the query - 2004, 2005, and 2007.
Recommendation When you select more than one of the year fields sup_tax_yr, prop_val_yr, owner_tax_yr, tax_yr, sup_yr, and exmpt_tax_yr, we recommend that you do the following: