Newbie | Building Report with Many Fields
I have built a database with around 500 fields or which 400 or them are similar fields. Meaning, I have (Acc Owner 1, Acc Owner 2, Acc Owner 3, etc.) I want to build a report that will only list the field that have data in them. To make this more complicated, I have ten rows with 10 fields across. The rows are a group of data fields that go together. So, if I have data in one row, then I want the entire row to be shown in the report. I don't want empty rows in my report though. Is this possible? Do I need to set up my data fields differently? Any help would be greatly appreciated as I have completely hit the wall.