Chart problem in Access 97

[David]

Hello everyone:

I need some help in Access 97 I have created a database that contains
information about skateboarding for the our research group, I have created
seperate tables for age, gender, in-blades etc, I have created a form with
combo boxes to make input easier, so what i nedd help with is I would like
to make a chart or graph in a report that displays age only and then another
report with chart or graph to display gender only with a list of
percentages, can this be obtained direct from the form or do I need to put a
query into place?.

Thanks for anyone who can help with this
David

 

[Arvin Meyer]

You do need to use a query if your data is normalized correctly. From your
description, it sound like it may not be. A table describes an entity;
entities have attributes. Age is a calculation, you should be using
birthdate. Gender is an attribute of the Person entity, as is the name and
birthdate. You can learn more by reading something like:

Database Design for Mere Mortals by Michael J. Hernandez
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access