I have a formula that is located in the detail section that is looking for information by form# A job can have sevaeral forms or only one. If a job has several forms and has duplicate data on a certain field in that form, I want to suppress all duplication.

It works fine on the field, but not the entire section.

Example Form #1 = 4/4,   Form #2 = 4/4. 

To the person doing the work, this is redundant and takes up space. Cyrstal does not see it that way because of form #1 and form #2, but it is the 4/4 that I want to target. There are 4 fields that make up this line in the details section.

 

Any ideas.

I did. I know I must not be writing the formula correctly or using the correct location to enter. This seems like what I need though.

Where would it go, and what would this type of formula look like