Gareth Horton
August 5th, 2002, 04:13 PM
Q:When I go to the Table one of my fields keeps repeating the same thing until the value changes. Why?
A: Unless it repeats in the original report this is happening because you selected this field as an Append or Footer.
Appends and Footers will repeat until another Append/Footer occurs. The field selected as the Append or Footer is "appended" to each occurrence of the detail in a given record, so if there are four lines of detail, the field will be appended four times, or "repeated" for every line of detail encountered.
Building a Summary will provide you with the Option to Suppress Duplicates in the Properties /Display Tab of the Keyfield. The Keyfield must be created by an Append Template.
A: Unless it repeats in the original report this is happening because you selected this field as an Append or Footer.
Appends and Footers will repeat until another Append/Footer occurs. The field selected as the Append or Footer is "appended" to each occurrence of the detail in a given record, so if there are four lines of detail, the field will be appended four times, or "repeated" for every line of detail encountered.
Building a Summary will provide you with the Option to Suppress Duplicates in the Properties /Display Tab of the Keyfield. The Keyfield must be created by an Append Template.