I have created a report from an Access 2007 query. I am trying to insert a chart to display the information in a graphical format. When I launch the Chart Expert and click on the Data tab, I don’t see all the fields that are in the query. Why is that?
The query goes against several tables used to store data from a survey. It contains location, question, answer and count_of_question_numbers (a sum of all the questions that had ‘yes’ for the answer)(underscores are here just for readablility). All I see in the chart expert are location and count_of_question_numbers. So when it builds the chart, it assigns numbers to the questions instead of letting me assign the question with the count_of_question_numbers value. I hope that makes sense. Does anybody have any suggestions on how I can get this to do what I need it to do?
TIA
RenaG (BOB member since 2011-04-11)