Can I create a report a little like a cross tab query but without adding anything up

Hi there,



Thanks in advance for taking the time to look



I want to present some data in what seems to me like it would be a very natural and normal format, however have so far been unable to figure out how to do it. :banghead:



I record attendance data for a children's after school club in a table as follows (simplified):



AttendanceID - autonumber

AttendeeName - text

AttendanceDate - date

Attended - True / False



The data looks like this in the table:







I would like to be able to easily see who attended on which days, so I would like to therefore see the data laid out like this:









The Crosstab query looks almost like it would do what I wanted, however it seems to insist on adding something up, rather than just showing me the value true or false.



I hope this makes sense and that someone can advise on a way forward.



Thanks,



Alan

Can I create a report a little like a cross tab query but without adding anything up