Hello,
I hope I am in the right area to ask this question. I am trying to create a chart in Access but havent done it before, so I need some assistance.
1). I have the following data:
Code CountOfType Month Q 3 3/1/2012 K 1 2/1/2012 CDSA 1 2/1/2012 C 3 2/1/2012 W 1 12/1/2011 W 2 11/1/2011 CDSA 1 11/1/2011 W 2 10/1/2011 G 2 10/1/2011 C 1 10/1/2011
2). I dont to create a chart where I am showing the transaction count (countoftype) in the Y axis and the code and bill_date in the Y. I want the chart to show the transaction by code and show what month it occurred. Would this be a crosstab query?
Thanks