Report Layout

[joanne.hon]

I have a report which details the following:

Course Name, Location, Date

On the row beneath, the report then lists the number of people
"registered" for that course.
Then, the next row lists the number of people on the "waiting list"
and the one below that is the number of people "attended" etc.

Is there a way of getting all of the details to appear on the one row,
per course.

I think it appears this way, because the data is derived from a query
which 'counts' the colum by group?

 

[sherwin verdun]

yes, there is! change your query to simple query.