Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How can i do?.

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question