How can i do?.

[Former Member]

I got a table with data like this....

Class Classdate Classtime Instructor AttendeeName

MS Access - AM 08/11/2008 08.00 Evan James Jill Bryan

MS Access - PM 08/11/2008 13.00 Evan James Maya Mayer

MS Access - AM 08/11/2008 08.00 Evan James Bill Smith

MS Access - PM 08/11/2008 13.00 Evan James Eva Madis

MS Access - AM 08/11/2008 08.00 Evan James Tim Tanker

MS Access - PM 08/11/2008 13.00 Evan James Joe Biden

MS Access - PM 08/12/2008 13.00 Evan James Maya Mayer

MS Access - AM 08/12/2008 08.00 Evan James Bill Smith

MS Access - PM 08/12/2008 13.00 Evan James Eva Madis

MS Access - AM 08/12/2008 08.00 Evan James Tim Tanker

MS Access - PM 08/12/2008 13.00 Evan James Joe Biden

From this table...i want to create report like this....how can i do?. do i need to create a view?.

Class : MS Access - AM

Class Date : 08/11/2008 - 08/12/2008

Classtime : 08.00

Attendeename 08/11/2008 08/12/2008

Jill Bryan Y N

Bill Smith Y Y

Tim Tanker Y Y

Class : MS Access - PM

Class Date : 08/11/2008 - 08/12/2008

Classtime : 13.00

Attendeename 08/11/2008 08/12/2008

Maya Mayer Y Y

Eva Madis Y Y

Joe Biden Y Y

[Former Member · Accepted solution]

Hi..

--Create a report with Class as group

--Take Minimum(datetime) to get start time

--Take Min and Max of date to get date from and to.

--Take all AttendeeNames and suppress if duplicated

--Aslo you will have to write few formulas to get Y or N flag.

Hope this will help you.

Regards,

Sastry

[Former Member · Accepted solution]

Looks like you also want a second group on attendee, with a formula that tracks their attendance.

All of the basic class information would be in the Group Header for Group 1.

The student information would be in the Group Footer for Group 2.