I am trying to create a report in Access 2010. I have mutliple rows where one column either is 0 or 1. What I would like to do is have a section or group of items where column1=0 and a group of items where column1 =1. Then I can add separate headings and column names like the following:
Company Flavor Size
Pepsi Cherry 12oz
Coke Grape 16oz
Company Item Calories
BK Whopper 1000
Mcd Nuggets 500
So, my two groups are soda and food (0 or 1), columns are different based on group, and the data is displayed.
Any help on this would be greatly appreciated!