I''ve got a database set up which I use to keep student's marks, attendance
etc (I'm a teacher).
Ok, now I have a table of student names and one of test descriptions and one
of marks. The marks table has foreign keys to identify the student and the
So far, so good.
Now, what I want to be able to do is to view (on a form) or print (report?)
a mark sheet.
I've managed to set up a crosstab query which gives me the information I
want, but I don't know how to then use that in a report or form. When I try,
the form seems to take a snapshot of the current crosstab results, so if I
add another test to the database (with associated marks) they aren't shown.
How do I do this please?