G
Guest
I work for a publication that wants to keep track of all our stories, the
category they fall into, and the area of town that they cover. I have created
a simple table with all of the stories, categories, and areas, along with
other information (date, etc.) My problem is that some of the stories fall
into more than one category or area. In my table I have "Area1" and "Area2"
columns. I want to create a report with a pie chart that shoes the division
of the stories for the year by area. This means, I need to create query that
combiens the "Area1" an "Area2" columns into one "Area" column. I know that
some stories in this query would be duplicated. How should I go about this?
I'm brand new to Access, so very detailed help would be GREATLY appreciated!!
category they fall into, and the area of town that they cover. I have created
a simple table with all of the stories, categories, and areas, along with
other information (date, etc.) My problem is that some of the stories fall
into more than one category or area. In my table I have "Area1" and "Area2"
columns. I want to create a report with a pie chart that shoes the division
of the stories for the year by area. This means, I need to create query that
combiens the "Area1" an "Area2" columns into one "Area" column. I know that
some stories in this query would be duplicated. How should I go about this?
I'm brand new to Access, so very detailed help would be GREATLY appreciated!!