Simplifying results from many to many relationships

[Colin]

I have created a large database for school students
choosing from a range of activities over a week. This part
works fine.
Each activity is on one or more days over the week and all
staff are assigned to one activity each day giving a many
to many relationship. I have a linking table so I can cross
reference both activities & staff but end up with several
rows for each staff member - one for each activity over the
week e.g.

Staff Mon Tues Wed
AN CDT
AN BBC
AN XYZ

This makes it difficult to view when creating reports of
staff usage. How can I create a query or report which will
display all activities for each member of staff as 1 record
i.e. on 1 row.
I also have the same issue with activities & rooms. I
should be able to adapt any solutions offered to manage this.
Thanks in advance

Colin

 

[John Vinson]

This makes it difficult to view when creating reports of
staff usage. How can I create a query or report which will
display all activities for each member of staff as 1 record
i.e. on 1 row.

Use a Crosstab query, using Weekday([datefield]) as the Column Header.

John W. Vinson[MVP]