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

sistemalan

Registered User.
Local time
Today, 23:48
Joined
Jun 19, 2009
Messages
77
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:

11053204_10153268791892494_7465330278065706045_n.jpg


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:

11046630_10153268796462494_2035824647110288200_n.jpg



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
 

Users who are viewing this thread

Back
Top Bottom