Line graphs in reports

K

kjmeyer

Hi all,
Newbe here. I am designing a database that will track studnet test results over a three year period. There are 9 tests taken twice a year for three years. I was hoping to display a line graph depicting the progress (or lack thereof) of a student when viewing their record in the database. Considering that there are 9 tests I will have to multiple graphs per record.

My questions are, 1: is this possible? 2:Are forms the place to display these graphs or perhaps a report would be better? and 3:Can someone point me down the correct path to get started

Thanks
kjmeyer
 
D

Damon Heron

Reports are the way to go. In report design, click view, charts. It is a
good idea to design a query prior to this to extract the data that way you
want it, then using the chart wizard, select your query as the source of the
chart. Also check out HELP for charts.

HTH
Damon

kjmeyer said:
Hi all,
Newbe here. I am designing a database that will track studnet test results
over a three year period. There are 9 tests taken twice a year for three
years. I was hoping to display a line graph depicting the progress (or lack
thereof) of a student when viewing their record in the database. Considering
that there are 9 tests I will have to multiple graphs per record.
My questions are, 1: is this possible? 2:Are forms the place to display
these graphs or perhaps a report would be better? and 3:Can someone point
me down the correct path to get started.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top