School report

  • Thread starter Thread starter Terapixels
  • Start date Start date
T

Terapixels

Hi All,

I have 18 sheets with identical structure. Each sheets contains all the
pupils name and ALL the subject they take. The sheets are then filled in by
the teachers.

Sheet structure:
( For example this is the math sheet)
Name, Option A, Option B, Option C, Option D, MathComment , MathTarget
Peter, Math1, Science3, Tech4, Art1, Excellent, Be
better
Susan, Math4, Science5, Food1, Art2, V. Good, Revise
Emma, Math3, Science2, Graphics1, Art2, Poor, Behave

( Science sheet)
Name, Option A, Option B, Option C, Option D, ScienceComment ,
ScienceTarget
Peter, Math1, Science3, Tech4, Art1, Excellent, Be
better
Susan, Math4, Science5, Food1, Art2, V. Good, Revise
Emma, Math3, Science2, Graphics1, Art2, Poor, Behave

( Tech sheet)
Name, Option A, Option B, Option C, Option D, TechComment , TechTarget
Peter, Math1, Science3, Tech4, Art1, Excellent, Be
better
Susan, Math4, Science5, Food1, Art2,
Emma, Math3, Science2, Graphics1, Art2,

( Food sheet)
Name, Option A, Option B, Option C, Option D, FoodComment , FoodTarget
Peter, Math1, Science3, Tech4, Art1,
Susan, Math4, Science5, Food1, Art2, V. Good, Revise
Emma, Math3, Science2, Graphics1, Art2,


And I want this to print out per pupil,

Peter,

MathComment , MathTarget
Excellent, Be better

ScienceComment , ScienceTarget
Excellent, Be better

TechComment , TechTarget
Excellent, Be better

Is this possible?
TIA

Tera
 
Not sure what you mean by a sheet? Is this really an Excel question, or do
you have each class stored in a separate table within Access?

Sam
 
sorry, should be tables.


Sam said:
Not sure what you mean by a sheet? Is this really an Excel question, or do
you have each class stored in a separate table within Access?

Sam
in
Click to expand...
 
This is not the right way to put tables together in Access. The data needs
to be broken down to multiple tables with relationships between them.

For an introduction to this idea, see:
Relationships between Tables (School Grades example)
at:
http://allenbrowne.com/casu-06.html
 
Back
Top