watercooler
Programmer
I have a simple query that I need to graph. The query looks like this:
relMonth CountOfIssues RunTot2
Aug '03 12 12
Oct '03 1 13
Nov '03 7 19
Dec '03 2 21
Jan '04 2 23
Feb '04 11 34
Mar '04 5 39
Apr '04 31 70
May '04 3 73
Jun '04 12 85
Jul '04 130 215
Aug '04 1 216
RunTot2 uses DSum to collect a running sum of new issues. Anyway, all I want to do is generate a bar chart with RunTot2 as the y-axis and relMonth as the x-axis. Access keeps trying to do a count of RunTot2 and it won't let me choose it to take no action when I double click on the button in the Chart Wizard. This is dead simple to do in Excel so I am assuming that there is a very simple solution in Access...I just can't see it.
Any help is much appreciated,
Rob
relMonth CountOfIssues RunTot2
Aug '03 12 12
Oct '03 1 13
Nov '03 7 19
Dec '03 2 21
Jan '04 2 23
Feb '04 11 34
Mar '04 5 39
Apr '04 31 70
May '04 3 73
Jun '04 12 85
Jul '04 130 215
Aug '04 1 216
RunTot2 uses DSum to collect a running sum of new issues. Anyway, all I want to do is generate a bar chart with RunTot2 as the y-axis and relMonth as the x-axis. Access keeps trying to do a count of RunTot2 and it won't let me choose it to take no action when I double click on the button in the Chart Wizard. This is dead simple to do in Excel so I am assuming that there is a very simple solution in Access...I just can't see it.
Any help is much appreciated,
Rob