accessinformation
Technical User
Hello...I created a report which has a field for "County" (there are two counties). Each county has three different categories (fld_Category) which appear in the group. I would like the county to appear in the first section for the group so I placed the fld_County in the group header. I do not want it to appear in the other two categories.
I tried the property "hide duplicates" but it did not work
Example of what I mean
Los Angeles County
Category 1 Data Data Data
Category 2 Data Data Data
Category 3 Data Data Data
Orange County
Category 1 Data Data Data
Category 2 Data Data Data
Category 3 Data Data Data
As of now, the couty appears between each category as such:
Orange County
Category 1 Data Data Data
Orange County
Category 2 Data Data Data
Orange County
Category 3 Data Data Data
I hope this makes sense. Any and all help would be greatly appreciated.
Thank you
I tried the property "hide duplicates" but it did not work
Example of what I mean
Los Angeles County
Category 1 Data Data Data
Category 2 Data Data Data
Category 3 Data Data Data
Orange County
Category 1 Data Data Data
Category 2 Data Data Data
Category 3 Data Data Data
As of now, the couty appears between each category as such:
Orange County
Category 1 Data Data Data
Orange County
Category 2 Data Data Data
Orange County
Category 3 Data Data Data
I hope this makes sense. Any and all help would be greatly appreciated.
Thank you