joining crosstabs for a report - showing each 6 weeks

[Guest]

I have a 1st crosstab that shows a (a) last name, (b) first name (c) class and (d)their letter grades by class [Note only 6 classes that everybody takes] for their first 6 weeks, and a 2nd similar showing the 2nd six weeks grades. It is nice to be able to see the grades from each six weeks
BUT it would also be nice to see each students' progress from 1st 6 weeks to 2nd six weeks (and 3rd six weeks and semester). I 'think' I could union the 2 crosstabs and then make a report, which would be nice to join each students grades, but how would I know which grade set is the first 6 weeks and which is 2nd, etc?

 

[Graham R Seach]

John,

Don't union the two queries, just create a subreport using one of the
queries.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I have a 1st crosstab that shows a (a) last name, (b) first name (c) class

and (d)their letter grades by class [Note only 6 classes that everybody
takes] for their first 6 weeks, and a 2nd similar showing the 2nd six weeks
grades. It is nice to be able to see the grades from each six weeks.

BUT it would also be nice to see each students' progress from 1st 6 weeks

to 2nd six weeks (and 3rd six weeks and semester). I 'think' I could union
the 2 crosstabs and then make a report, which would be nice to join each
students grades, but how would I know which grade set is the first 6 weeks
and which is 2nd, etc?

 

[Guest]

I don't see/know how this will show what I want/need.

 

[Graham R Seach]

John,

Create a report that shows the student's name, plus the first 6 weeks data.
Then create a new report that shows the next 6 weeks data. Then add the
second report to the first as a subreport, linking on StudentID (or some
such field). You can create and add as many subreports as you like, showing
as many 6-week blocks as are necessary.

About the only difference between the query for the first report, and that
for subsequent reports, is that the date should be filtered:
WHERE ClassDate > DateAdd("w", 6, startdate)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia