Chart Problem

[David]

Hello:

I am doing a database that records all about different area's of
skateboarding, i don't profess to be an expert but i have made seperate
tables one with age and one with gender these are connected to the main form
via a combo box, so all the user needs to do is click on the drop down box
and select age than gender.
My problem is i need to produce a report that shows all the ages from 8yrs
to 17yrs only then produces a report with a built in graph or chart that
shows the ages on one axis and percentages on the other axis, can this chart
pick up information depending on how the age is selected in a form or not??.

Anybody's help would be appreciated, thanks for any initial input guy's.
David

 

[Tim]

Hi David

Sure, base the report or chart on a query

The query can include a reference to the combo box (or text box or ...) in the form using the following syntax
[Forms]![frmName]![subformName]![comboName

Hope this helps

Tim.