Report for Course Attendees

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a report from a database that would list attendees down the
left column and has the course name across the top with the date they
attended in the column below. So the report might look something like:

Course 1 Course
2 Course 3
Attendee 1 (date) (date)
(date)
Attendee 2 (date) (date)
(date)

I do not even know where to start. Can someone pleaesseeeee help me? I have
to have this done by Monday morning!!

Thanks!
karen
 
Have you tried a crosstab query? Set the attendee as the Row Heading, Course
as the Column Heading, and First Of Date as the Value.

Reply back when you hit a snag.
 
OHMIGOSH! You are the smartest man ever! It worked like magic! Thanks so
much! I had tried this but what I wasn't doing was the "First of Date" as
the value.

Thanks again!
 
Back
Top