Event and Particpant Report

[WolfeHall]

I have a database to track the participation of our clients in our training
programs. Currently the database is set up with tblClients, tblEvents,
tblAttendees, tblEventType (pretty self explanatory as to the relationships,
but happy to elaborate if needed).

I have a report - Training Usage which currently has a subreport to show All
available training sorted by Event Type printing as the Report header, and
the actual report grouped by Client showing the events (grouped by Event Type
- and sorted by Attendee) that the client participated in. This works great,
but it generates one list of all available training and then a separate page
of training attended by the client (and prints no report for clients that
haven't attended any training).

Management wants to see a Client report that shows All Available training
grouped by Event Type (basically my All Available report) with detail below
of the Attendees for those events in which the client did participate. They
want all available training to appear - and blank lines if the client didn't
participate - and a blank report if the client didn't attend anything. I
can't seem to get Access 2007 to display events that don't have Attendees.
It works fine if there are Attendees.

How do I get the report to display all events, even if there is no detail in
the record?

 

[Jeff Boyce]

If you create a query that goes from the Event table to the Attendees table,
and use a directional join (click on the connecting line, change the join
properties so that all Event records AND any 'matching' Attendees.

Then, in your report, Group on your Events and display Attendees in the
Details section.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP