Creating a graph in Access VBA

[Cineno]

I'm trying to create a bar graph that shows the distribution of scores in one of my tables.

The X-axis should have the scores separated by ranges (ex. 60-65, 66-70, 71-75, etc.)

The Y-axis should have the number of people falling into those ranges.

I've tried to create this with queries and the chart-wizard, but couldn't get it right. The problem is that the scores aren't separated into ranges in the table, there's only the "Score" field for everyone.

I figured doing something in VBA would do the trick. Anyone know how to go about this? Thanks for any help!

 

[SkipVought]

What does your query look like?

Skip,

_{I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!}

 

[Cineno]

Well I've tried a few queries, but I stopped because I don't know to make them work with the chart anyway. For example, I could do a query for scores between two numbers, but I don't know how assign each range to a new bar, or any of that stuff.

Sorry if this is elementary, it's my first time trying to make charts in Access. I figured VBA could give me more room to specify what I want, but I haven't found too many examples.