COMPARISON CHARTS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to compare data from different years for the same examination each
year. Cannot seem to be able to compare data from more than 1 table. Have
been able to create a report based on one years data. Have data for each
year in a different table. Would like to be able to show a graph for each
person comparing their results in the exams from year to year. Can anybody
help please.
 
The heart of the problem is that the data for each year is in different
tables. That's a bad design! Create a query that includes all the tables
containing data you want to compare. Join the tables on StudentID. Include
the fields from each table you want to compare.
 
Back
Top