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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating report 4
Add lines or blanks to report 4
Field name in report title 1
USING SUMPRODUCT 2
Report is only showing first couple of records on page on, no other pages 2
best database to use for multiple attendence at meetings 7
New page for subreport 1
How to combine data from 2 separate workbooks onto 1 worksheet 2

Back
Top