Sir Babydum GBE
04-29-2009, 08:36 AM
Hello my old friends. I'm happy to say that reports about my demise have been greatly exagerrated. I am very much alive. I've given up sooth-saying and now live in Frinton with a Seagull
Now to my question:
I want to create a list of activities for each day that contains the following column headers:
Date; Activity; Host; Attendee 1; Attendee 2; Attendee 3; Attendee 4 and so on - perhaps up to 30 attendees.
I don't want to create a seperate line for each attendee because I and my co users are far too lazy for that.
Would there be a way for my to have a list like that but have all the attendee columns treated as one so that, for instance, I might want a pivot to report how many times Betty attended activities in March without having it broken down to Attendee 1; Attendee 2 etc. Or I might want to see if Brian attended art class on May 15th, and so on.
I would normally use a pivot for such reporting but can I with a setup like this?
many thanks
Sir BD
Now to my question:
I want to create a list of activities for each day that contains the following column headers:
Date; Activity; Host; Attendee 1; Attendee 2; Attendee 3; Attendee 4 and so on - perhaps up to 30 attendees.
I don't want to create a seperate line for each attendee because I and my co users are far too lazy for that.
Would there be a way for my to have a list like that but have all the attendee columns treated as one so that, for instance, I might want a pivot to report how many times Betty attended activities in March without having it broken down to Attendee 1; Attendee 2 etc. Or I might want to see if Brian attended art class on May 15th, and so on.
I would normally use a pivot for such reporting but can I with a setup like this?
many thanks
Sir BD