COMPARISON CHARTS

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.
 
P

PC Datasheet

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.
 

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

Similar Threads

How to chart months by financial year 0
Graph of prices by date with each year as a separate line 1
Multiple Versions of Same Report 9
Compare 1st qtr this year to 4th qtr last year 13
Best Method Comparison Report 1
Comparison Report based on a query of only calculations. 17
Excel Changing chart label colors based on a value in a cell 0
line graph question 6

Top