OK, Here is the run down. I originally created the report expecting to only have 1 record. I now have to modify the report to suppress the first record if the second one exists. The report is grouped by index number field. "ID" of which can be 1 or 2 records. I would like to only show the first record if the second one doesn't exist and suppress the first record if a second one exists.
I have sub reports that are grouped by the same ID field and are also showing two records at a time. Any suggestions ?