linking reports

[sir_dan_mitchell]

hey,

I have a little problem with creating a report. I have tables where i link courses to staff so one staff memeber can have many courses etc. I want a report to show how many people are on each course! However each course is split up into beginner, intermidiate and expert levels! I want to create a report that will show who is on which specific course ( and the actual numbers ); this will seperate excel beginner, and say expert. The levels, beginner, intermidiate and expert are selected from the form when the course is booked from a list of values!

I am having immence problems with this can somebody help?

Thanks Dan

 

[GlennL]

A little more information about how your course codes are set up may help but your post suggests that you have a single course code and within that code three levels can be chosen.

So long as the level is stored in a table somewhere, it sounds as though you should have a group on course code, and then beneath that have a group on level.

In the detail section place the students codes/names etc that you wish to see, and for level counts add a statement such as =count([stucode]) to count by level, add it again in the course code grouping for an overall count.

If all you want is a count, doing it this way you could simply make the details section invisible.

Does that help at all? Or have I got the wrong end of the stick?