Hello everyone!
I am running into a small issue when trying to create a chart in a report in access 2010.
I have a simple table that I am running a simple query off of. The query is pulling the birthday from everyone in the table as well as the date that they signed up. From there, I created a calculate field called "SignUpAge" which uses the birthday and signup date to calculate a sign up age.
So far, everything seems to be going just as I would like.
The problem is, I want to create a bar chart that displays "SignUpAge" from the query. I can create a chart with no problem, but how the chart is displayed is what is giving me trouble. For instance, I want it to be grouped in chunks. Age 1-10 would be one bar, 11-20 would be the next, etc.
I can only get it to display grouped by each individual age, not by each age range.
I feel like I need to create a summary table of some sort , to somehow count the number of "SignUpAges" that fall between each age band.
How I would go about doing that is beyond me though.
Any help that could be given would be extremely appreciated.
Thank you !
James