Dynamic form/report layout (crosstab?)

Dynamic form/report layout (crosstab?)

Post by UGF1bCBTaW » Sat, 26 Nov 2005 02:03:07


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?

Many thanks,

Paul Simpson

Dynamic form/report layout (crosstab?)

Post by Duane Hook » Sat, 26 Nov 2005 10:33:00

There are some sample crosstab reports at
solution that should work.

Duane Hookom
MS Access MVP