L
larryo
I am relatively new to Access, and am attempting to develop a Client database
for a non-profit. So far I think I've done fairly well with tables and input
forms. Now I am starting to develop Reports.
One of the inputs on the form is date of birth. I have created a query
that, by using an expression, enables me to calculate age from date of birth.
(Ages range from 21 through 93, but not every one is populated - for
example, there might be three clients aged 41 but none age 42, and then 2
aged 43, etc.) Now I'd like to create a report that I can eventually put in
graph (bar chart) showing those ages on the x axis, and the number or
quantity on the y axis. I have spent about three hours going over Q&A in the
discussion group and I guess if I poked around for another day or so, I might
be able to figure it out but I'm hoping someone can point me in the right
direction. At this point, after reading all those Q&A's, I'm pretty much
confused. Do I do another query to do this, or a report, or what?
for a non-profit. So far I think I've done fairly well with tables and input
forms. Now I am starting to develop Reports.
One of the inputs on the form is date of birth. I have created a query
that, by using an expression, enables me to calculate age from date of birth.
(Ages range from 21 through 93, but not every one is populated - for
example, there might be three clients aged 41 but none age 42, and then 2
aged 43, etc.) Now I'd like to create a report that I can eventually put in
graph (bar chart) showing those ages on the x axis, and the number or
quantity on the y axis. I have spent about three hours going over Q&A in the
discussion group and I guess if I poked around for another day or so, I might
be able to figure it out but I'm hoping someone can point me in the right
direction. At this point, after reading all those Q&A's, I'm pretty much
confused. Do I do another query to do this, or a report, or what?