Dynamic form/report layout (crosstab?)

[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

 

[Duane Hookom]

There are some sample crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The Crosstab.mdb has a
solution that should work.