Dynamic form/report layout (crosstab?)

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

Guest

Hi,

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

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?

Many thanks,

Paul Simpson
 
Back
Top